Answer Posted / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Enterprise data warehouse your projects phase by phase explain?
expain about the tune parameters?
What is a node in Informatica?
What are the different lookup cache(s)?
What are junk dimensions?
How can we handle two sessions in informatica?
What is depict expression change?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain sessions. Explain how batches are used to combine executions?
How can a transformation be made reusable?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What could be the possible resons of locks by user?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How can we use batches?
How can we store previous session logs?