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
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How many areas for files does datastage have?
What are the various kinds of containers available in datastage?
What can we do with datastage director?
What could be a data source system?
Define ds designer?
What are some prerequisites for datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Differentiate between hash file and sequential file?
What are the different options associated with dsjob command?
Describe the architecture of datastage?
What is orabulk stage?
Is possible to create skid in dim,fact tables?
Difference between sequential file and data set?
what are the errors,warnings in datastage