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 / nagaraz
1.READ METHODE SHOULD BE TAKE SPECIFIC FILE U CAN TAKE
MULTIPLE FILE
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I have a few records just I want to store data in to targets cycling way how?
Triggers,VIEW,Procedures
Describe routines in datastage? Enlist various types of routines.
What is the process of killing a job in datastage?
Explain connectivity between datastage with datasources?
What is the roundrobin collector?
What are stage variables?
what is the use of materialized view?
What are the difference types of stages?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are data elements?
Describe the main features of datastage?
Enlist various types of routines in datastage.
What are the functionalities of link collector?
How complex jobs are implemented in datstage to improve performance?