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 difference between symmetric multiprocessing and massive parallel processing?
What is meta stage?
what is the use of skid in reporting?
Differentiate between odbc and drs stage?
How can you write parallel routines in datastage PX?
EXPLAIN SCD
Can you implement SCD2 using join, transformer and funnel stage?
Can you explain repository tables in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is oci?
Why fact table is in normal form?
What are the repository tables in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the command line function to import and export the ds jobs?