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


Please Help Members By Posting Answers For Below Questions

What is staging variable?

613


what is the difference between == and eq in UNIX shell scripting?

964


Name the different types of Lookups in Datastage?

718


CHANGE CAPTURE

879


Does datastage support slowly changing dimensions ?

651






How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1074


What is active and passive stage?

870


How to convert RGB Value to Hexadecimal values in datastage?

3448


What is the importance of the exception activity in datastage?

614


If you want to use the same piece of code in different jobs, how will you achieve it?

625


how can we create rank using datastage?what is the meaning of rank?

8154


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2017


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2416


To see hidden files in LINIX?

939


What is a merge?

660