Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is the importance of the exception activity in datastage?

1014


What are data elements?

1100


Which commands are used to import and export the datastage jobs?

1358


Describe the architecture of datastage?

949


What is data partitioning?

1135


how to export or import the jobs in .ISX file

1132


What are stage variables, derivations and constants?

1161


How many areas for files does datastage have?

1082


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2404


Where the datastage stored his repository?

1018


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2127


What are the processing stages?

1037


How to RD using transformer?

1360


Give an idea of system variables.

960


Lookup constraints

1199