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
project Steps,hits, Project level HArd things,Solved methods?
Define project in datastage?
Does datastage support slowly changing dimensions ?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How do you reject records in a transformer?
What are iconv and oconv?
What is "fatal error/rdbms code 3996" error?
What are the differences between datastage and informatica?
describe the Steps to confiure a Qlogic switch
What are datastage sequences?
What is meta stage?
What is the use of datastage director?
Which commands are used to import and export the datastage jobs?
What is the difference between hashfile and sequential file?
What are the different types of lookups in datastage?
