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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the difference between datastage and datastage tx?
What is the project in datastage?
What is the use of datastage designer?
Lookup constraints
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to export or import the jobs in .ISX file
Define repository tables in datastage?
What are the important features of datastage?
what is flow of project?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the functionalities of link collector?
what are the devoleper roles in real time? plz tell i am new to datastage....