Tuesday 29 March 2016

Adding Multiple Physical Table Sources

Handson05: .Adding Multiple Physical Table Sources

  1. Table 1 and Table 2 have no direct join in physical layer. Can we map both in single LTS

    No .
  2. Detail table and aggregate tables will be added as two LTS to LT. Is it right?
    Yes, It is right .
  3. Using this concept we can convert Normalized/snow flake schema into denormalized / Star schema, is it right ?
    Yes we can do using below methods
    1. By integrating multiple physical tables into LTS  
    2. By integrating Multiple physical tables as multiple LTS to LT .

No comments:

Post a Comment