Adding Multiple Physical Table Sources
Handson05: .Adding Multiple Physical Table Sources
- Table 1 and Table 2 have no
direct join in physical layer. Can we map both in single LTS
No .
- Detail table and aggregate
tables will be added as two LTS to LT. Is it right?
Yes,
It is right .
- Using this concept we can
convert Normalized/snow flake schema into denormalized / Star schema, is it
right ?
Yes we can do using below methods
- By integrating multiple physical tables into LTS
- By integrating Multiple physical tables as multiple LTS to LT .
No comments:
Post a Comment