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
What can we do with datastage director?
What is the difference between datastage and informatica?
How can we improve the performance in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Describe routines in datastage? Enlist various types of routines.
Highlight the main features of 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?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How can one find bugs in job sequence?
CHANGE CAPTURE
What are data elements?
What is oci?
How the ipc stage work?
What is a ds designer?