1.How to read multiple file from sequential stage.
2.If a file doesn't arrive or doesn't exists in sequential
stage how do u handle this.
3.What do you do before taking data from source to staging
area.
4. I have a remove duplicate stage and transformer
stage.what will u do for optimizeing the performance of the
job.
Answer Posted / ashok
4.in case of only for duplicates removing i will use remove
duplicate stage.but in case of more logics applied i will
go to transformer.bcoz remove duplicate stage give better
performance compare to transformer
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the importance of the exception activity in datastage?
Where do you see different stages in the designer?
What are the different type of jobs in datastage?
What is the difference between datastage and informatica?
What are the different common services in datastage?
Define Job control?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How do you schedule or monitoring the job?
Differentiate between odbc and drs stage?
What is the difference between account and directory options ?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is a folder? Difference types of stages?
What are the difference types of stages?
If you want to use a same piece of code in different jobs, how will you achieve this?