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
How many areas for files does datastage have?
What is the difference between odbc and drs stage?
What are the types of containers and how to create them?
How to RD using transformer?
How do you generate sequence number in datastage?
What are the repository tables in datastage?
how to delete one row in target dataset
How do you reject records in a transformer?
table actions available in oracle connector?
What is meta stage?
State the difference between an operational datastage and a data warehouse?
Why fact table is in normal form?
What are the functionalities of link partitioner and link collector?
If you want to use a same piece of code in different jobs, how will you achieve this?
How to convert RGB Value to Hexadecimal values in datastage?