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
Answer Posted / rajupatel
Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
What is the difference between Active and Passive transformation?
What does cheating measurement mean?
What all are steps in up gradation of Informatica server?
How do you migrate data from one environment to another?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain the tuning lookup transformation - informatica
How to do unit testing in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Whats there in global repository
How identifying bottlenecks in various components of informatica and resolving them?
Explain the difference between mapping parameter and mapping variable?
What is a node in Informatica?
What does role playing dimension mean?