Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
- 5 Answers
- 23529 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek
ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
hi real timers . iam waiting for ur reply regarding ETL TESTING
How can we use mapping variables in informatica?
Informatica settings are available in which file?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain load alternative records / rows into multiple targets - informatica
What is difference between a gateway node and worker node?
What is the meaning of decode in informatica?
What is the meaning of up gradation of repository?
How to open an older version of an object in the workspace?
Why do we need informatica?
How to join three sources using joiner? Explain though mapping flow.
What is union transformation?
What is the Process to creating lookup transformation in informatica
How to go to the older version for a mapping?
Explain target update override in informatica
