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

What is rank transformation in informatica

801


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10369


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8929


What is a connected transformation?

782


What is aggregator transformation in informatica?

629






what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2020


Describe data concatenation?

665


Can we override a native sql query within informatica?

712


State the limitations where we cannot use joiner in the mapping pipeline?

636


What are the different clients of powercenter?

700


How does a rank transform differ from aggregator transform functions max and min?

787


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

625


What is Cognos script editor?

3867


What is the different lookup cache(s)?

712


How can we improve session performance in aggregator transformation?

760