Interested to Buy Any Domain ? << Click Here >> for more details...
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 main features of datastage?
Nls stands for what in datastage?
What are the differences between datastage and informatica?
Where do the datastage jobs get stored?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explain usage analysis in datastage?
How do you import and export data into datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
sed,awk,head
What is ibm datastage flow designer?
How rejected rows are managed in datastage?
Where do you see different stages in the designer?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Define APT_CONFIG in Datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
