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 active and passive stage?

876


What is process model?

1551


what is 'reconsideration error' and how can i respond to this error and how to debug this

2119


What is the difference between orabulk and bcp stages?

574


Can you filter data in hashed file?

3343






how to implement scd2 in datastage 7.5 with lookup stage

5129


Triggers,VIEW,Procedures

800


Notification Activity

897


How do you run datastage job from the command line?

598


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1803


What is the difference between passive stage and active stage?

824


What are the various kinds of containers available in datastage?

563


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1617


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...

1078


Why we use surrogate key?

697