Answer Posted / isha
Ralph Kimball's dimensional design approach (the bottom-up design): The data marts facilitating reports and analysis are created first; these are then combined together to create a broad data warehouse. Inmon defines data warehouse as a centralized repository for the entire enterprise.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is expression transformation?
Explain the etl program with few examples.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the data movement modes in informatica?
difference between informatica 8.1.1 and 8.6
What does refresh system mean, and what are its distinctive choice?
How to extract the informatica rejected data?
Is it possible to revert a global repository to local one and why?
What is complex mapping?
How would you join a node to the already existing domain?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain about cumulative Sum or moving sum?
What do you mean by filter transformation?
How do you promote a non-reusable transformation to reusable transformation?
What is a repository? And how to add it in an informatica client?