Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Global and Local shortcuts. Advantages.

0 Answers  


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  


can you please explain me pre session and post session options?

3 Answers   BTBP,


What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,






Without source how to insert record to target?

6 Answers  


Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


performance wise which one is better in joiner and lookup transformation

2 Answers  


I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,


When to use normalization transformation other than cobol source?

2 Answers  


what is bridge tables in informatica

1 Answers   CTS,


Name 4 output files that informatica server creates during session running?

1 Answers  


Categories