Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20930 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / bsgsr
i simply put this way.
source to staging
staging to dwh
| Is This Answer Correct ? | 2 Yes | 1 No |
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 |
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
How to eliminate duplicates from flat file..what is the procedure
What is CDC? How to implement CDC?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
how to load duplicate row in a target
Which is costliest transformation? costly means occupying more memory?
If I have a index defined on target table and if set it to bulk load will it work ?
How to delete the data in the target table after loaded.
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
How to jion 2 tables, without using any condition?
Teradata 
