step-01------>source to staging step-02------>staging to dimension

what is the architecture of any Data warehousing project?

Question Posted / praveen kumar

Answer Posted / praveen kumar

step-01------>source to staging
step-02------>staging to dimension
step-03------>dimension to fact

This is the general procedure.........

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention some types of transformation?

1009

How to load data in informatica ?

971

Is it possible to create multiple domains on a single Informatica server?

1196

How to update source definition?

1047

Can you generate sequence numbers without using the sequence generator transformation?

1069

How to create a non-reusable instance of reusable transformations?

1074

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2082

What is workflow? What are the components of workflow manager?

1139

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

1016

 Informatica Checkpoints

3279

How do you convert single row from source into three rows into target?

1106

scenario where i can use only concurrent execution of workflow.

3093

What is the advantage of informatica?

1027

What do you mean by channel change?

987

To import the flat file definition into the designer where should the flat file be placed?

1022