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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is workflow manager?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are different types of transformations available in informatica?
How can we handle two sessions in informatica?
Where is metadata stored?
How to update source definition?
What is update strategy transform?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the components of workflow manager?
How do you handle two sessions in Informatica
Explain your project of banking domian.
What is informatica? Why do we need it?