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 / guru avula

1.In a project source systems are differnet and also all
source systems are not availble in same time.for eg 1
source is availble at 1AM and 2n one at 2 AM etc
But our schedule jobs run at different time ,so we have to
pick the data from source system based on source availble
time and put into staging area.
2.All source systems table formats and column formats are
diffrent ,so we have to sync all .
For above two reasons we go for staging area

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are stage variables and constants?

1096


Define data aggregation?

1046


how to delete one row in target dataset

3061


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1450


What is staging variable?

1026


How complex jobs are implemented in datstage to improve performance?

962


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2406


root tree will find which is server job and which is parallel job?

1882


What is the difference between datastage and datastage tx?

1007


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1193


What are the steps required to kill the job in Datastage?

1148


What is quality stage?

937


What are constraints and derivations?

1112


What are the processing stages?

1039


What are the features of datastage flow designer?

991