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 difference between hashfile and sequential file?
How to read multiple files using a single datastage job if files have the same metadata?
What are the types of containers?
How do you remove duplicate values in datastage?
What are the steps needed to create a simple basic datastage job?
Can you explain kafka connector?
What are the job parameters?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define meta stage?
Explain usage analysis in datastage?
What is a folder? Difference types of stages?
Define Job control?
Difference between sequential file and data set?
sed,awk,head
What is "fatal error/rdbms code 3996" error?
