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
How rejected rows are managed in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Differentiate between Join, Merge and Lookup stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between hashfile and sequential file?
What are the different options associated with dsjob command?
How many types of stage?
Notification Activity
How do you import and export the datastage jobs?
Have you used Unstructured data?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the difference types of stages?
Define oconv () and iconv () functions in datastage?
How do you remove duplicate values in datastage?
