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

have u done any performance tuning? how u ll do?

2367

What do you understand by term role-playing dimension?

1118

Enlist the advantages of informatica.

1099

Define sessions in informatica etl?

1104

Where can we find the throughput option in informatica?

1107

How does the aggregator transformation handle null values?

1197

differences between service based and product based?

2060

Tell me about MD5 functions in informatica

983

What is substr in informatica?

1262

Explain lookup transformation source types in informatica

1152

What is a passive transformation?

1154

What is sorter transformation?

1111

what is the complex transformation you used in informatica

2624

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1212

expain about the tune parameters?

2458