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


Please Help Members By Posting Answers For Below Questions

update strategy transformation in informatica

627


How do you migrate data from one environment to another?

632


What is meant by LDAP users?

682


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7656


Explain the difference between a data warehouse and a data mart?

584






What is the different lookup cache(s)?

598


How many ways a relational source definition can be updated and what are they?

569


What is the Process to creating lookup transformation in informatica

570


What is the difference between a connected look up and unconnected lookup?

557


How to update source definition?

618


Define update strategy?

625


How can we improve session performance in aggregator transformation?

656


What is aggregate cache in aggregator transformation?

620


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1688


Have you worked with/created Parameter file

1213