What's the Main Function of the Staging area in DWH
Answer Posted / erwa
Preparing the Extracted Data to be loaded to the DWH.
Preparing like examine each extracted file, review the
Business rules, perform the various data transformation
functions, resolve inconsistencies, Sort & Merge data, etc.
| Is This Answer Correct ? | 25 Yes | 6 No |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
what is the use of surogate key in datastage
How do you remove duplicate values in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How many types of sorting methods are available in datastage?
Describe the architecture of datastage?
What all the types of jobs you developed?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between odbc and drs stage?
Define Data Stage?
What are the different layers in the information server architecture?
I have a few records just I want to store data in to targets cycling way how?
Define project in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are system variables and sequencers in datastage