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 to run a sequential file stage in parallel if the stage is used on the TARGET side
How many Key we can define in remove duplicate stage?
CHANGE CAPTURE
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the project in datastage?
How do u convert the columns to rows in datastage?
describe the Steps to confiure a Qlogic switch
How rejected rows are managed in datastage?
What is ibm datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the different types of lookups in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are stage variables and constants?
What is the difference between passive stage and active stage?