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 the types of jobs we have in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between hashfile and sequential file?
How to read the length of word in unix?
What are the processing stages?
Where the datastage stored his repository?
On which Dimension Table you implemented SCD Type in your Project
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the components of datastage?
What could be a data source system?
Differentiate between datastage and informatica?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the flow of loading data into fact & dimensional tables?
