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 is the command line function to import and export the ds jobs?
Notification Activity
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the steps required to kill the job in Datastage?
Define APT_CONFIG in Datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the differentiate between data file and descriptor file?
Define project in datastage?
How to reverse the string using unix?
What is the purpose of pivot stage?
To see hidden files in LINIX?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
On which Dimension Table you implemented SCD Type in your Project
Could anyone give brief explanation bout datastage admin
What are the difference types of stages?
