Main Function of the Staging area in DWH ?
- 2 Answers
- 5450 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guru avula
1.In a project source systems are differnet and also all
source systems are not availble in same time.for eg 1
source is availble at 1AM and 2n one at 2 AM etc
But our schedule jobs run at different time ,so we have to
pick the data from source system based on source availble
time and put into staging area.
2.All source systems table formats and column formats are
diffrent ,so we have to sync all .
For above two reasons we go for staging area
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / srinivas
I will add some points to first answer
Source system send the raw data what ever data they have simply they will send to us.
In staging we do the cleansing, remove-duplicate and null handling process and load the data into staging tables.
Then we applying business logic's and loading into dim and fact tables.
| Is This Answer Correct ? | 2 Yes | 1 No |
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the purpose of pivot stage?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
What are stage variables and constants?
what is the custome stage in datastage? how can we impliment that one? plz tell me
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
Teradata 
