what is the architecture of any Data warehousing project?

Answers were Sorted based on User's Feedback



what is the architecture of any Data warehousing project?..

Answer / 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

what is the architecture of any Data warehousing project?..

Answer / 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

what is the architecture of any Data warehousing project?..

Answer / rekha

PROJECT PLANNING
REQUIREMENTS GATHERING ---PRODUCT SELECTION AND INSTALLTION

DIMESIONAL MODELING --- PHYSICAL
MODELING ---- DEPLOYMENT --- MAINTENANCE

IN EASY TREMS FOR DIMENSIONAL MODELING
1. SELECT THE BUSINEE PROCESS
2 IDENTIFY THE GRANINS
3 . DESIGN THE DIMENSION TABLE
4 . DESIGN THE FACT TABLE
ONCE THESE 4 STPE ARE OVER IT WILL MOVE TO PHYSICAL
MODELING
IN PHYSICAL MODELING U APPLY THE ETL PROCESS AND
PERFORMANCE TECHNOQUES .

Is This Answer Correct ?    3 Yes 0 No

what is the architecture of any Data warehousing project?..

Answer / bsgsr

i simply put this way.
source to staging
staging to dwh

Is This Answer Correct ?    2 Yes 1 No

what is the architecture of any Data warehousing project?..

Answer / kumarapillaietl@gmail.com

first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


Why we use partitioning the session in informatica?

2 Answers  






What is difference between maplet and reusable transformation?

2 Answers  


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


what is materialized view?

2 Answers  


What is A complex mapping?

3 Answers   TCS,


what is the size of u r source(like file or table)?

0 Answers   HP,


What is router transformation

4 Answers   CSC,


How to recover sessions in concurrent batches?

3 Answers  


Categories