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
What are stage variables and constants?
Define data aggregation?
how to delete one row in target dataset
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?
What is staging variable?
How complex jobs are implemented in datstage to improve performance?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
root tree will find which is server job and which is parallel job?
What is the difference between datastage and datastage tx?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the steps required to kill the job in Datastage?
What is quality stage?
What are constraints and derivations?
What are the processing stages?
What are the features of datastage flow designer?