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
Briefly define reusable transformation?
What is informatica worklet?
Enlist the advantages of informatica.
What are the restrictions of union transformation?
What is the Rank index port in Rank transformation?
Do you find any difficulty while working with flat files as source and target?
How to convert multiple rows to single row (multiple columns) in informatica
Different circumstance which drives informatica server to expel records?
What is a snowflake schema?
Explain lookup transformation source types in informatica
can anyone explain me about retail domain project in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist some properties of sessions.
How might one distinguish in the case of mapping is right or not without associating session?
What is a sequence generator transformation?