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 / jayanthi
1)read method should be set as file pattern(for reading
single file it should be specificfile)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
State the difference between an operational datastage and a data warehouse?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between passive stage and active stage?
What is the importance of the exception activity in datastage?
Nls stands for what in datastage?
Differentiate between Join, Merge and Lookup stage?
which r the connectors used in san?
Define Merge?
What is the flow of loading data into fact & dimensional tables?
How do you generate sequence number in datastage?
What are the functionalities of link collector?
Have you have ever worked in unix environment and why it is useful in datastage?
What can we do with datastage director?
How one source columns or rows to be loaded in to two different tables?
What is job control?