what is the architecture of any Data warehousing project?
Answer Posted / veera reddy
Basically there are two types of architectures.
1. Top Down(Dependent) and 2. Bottom up(Independent)
In Top Down approach initially DW comes and then DM.
In Bottom Up approach intially DM comes and then DW.
Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is meant by pre and post session shell command?
Slowly changing dimensions, types and where will you use them
How can we delete duplicate rows from flat files?
What is intricate mapping?
Which development components of informatica have the highest usage?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the main issues while working with flat files as source and as targets ?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Differentiate between reusable transformation and mapplet.
what are 3 tech challenges/ common issues you face?
Explain pushdown optimization $pushdownconfig parameter - informatica
Briefly explain the aggregator transformation?
What is workflow? What are the components of workflow manager?
where to store informatica rejected data?