Interested to Buy Any Domain ? << Click Here >> for more details...
Main Function of the Staging area in DWH ?
- 2 Answers
- 6496 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 |
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
What are transforms and what is the differenece between routines and transforms?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the some differences between 7.x and 8.x version of datastage?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
How we can covert server job to a parallel job?
why do u need the IOS upgradation in a FC switch
What are orabulk and bcp stages?
How do you load 10 different sources with 10 different layouts to 10 different tables?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
Terminate Activity
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Teradata 
