Main Function of the Staging area in DWH ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

357


How do you start developing a datastage project?

659


What is the different type of jobs in datastage?

568


Define Job control?

672


Explain how a source file is populated?

759






Can you highlight the main features of ibm infosphere information server?

633


How to find value from a column in a dataset?

1764


How to RD using transformer?

854


What are the types of containers?

677


What is orabulk stage?

624


Define orabulk and bcp stages?

670


Can you filter data in hashed file?

3338


What is the differentiate between data file and descriptor file?

858


What is the use of datastage designer?

633


how to export or import the jobs in .ISX file

710