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
how to create user defined function (udf) in informatica
What is meant by pre and post session shell command?
What is different between the data warehouse and data mart?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the function of aggregator transformation?
What is informatica worklet?
Explain dynamic target flat file name generation in informatica
Can we create two repositories on same database instance in oracle?
What is the difference between STOP and ABORT options in Workflow Monitor?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain target update override in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what is the -ve test case in your project.
Suppose we do not group by on any ports of the aggregator what will be the output?
