what is the logic will you implement to load data into a
fact table from n dimension tables?
- 4 Answers
- 18519 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / elango
fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a sorter transformation?
What are the different ways to implement parallel processing in informatica?
What is the difference between a connected look up and unconnected lookup?
Can we create multiple integration service on single repository?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the different types of olap? Give an example?
What is meant by incremental aggregation?
Why update strategy and union transformations are active? Explain with examples.
State the differences between sql override and lookup override?
Explain lookup transformation in informatica
How can you define user defied event?
What is Data Caches size?
Explain the difference between a data warehouse and a data mart?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the data movement modes in informatica?
