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


Please Help Members By Posting Answers For Below Questions

What are the types of containers in datastage?

713


Is the value of staging variable stored temporarily or permanently?

587


How do you run datastage job from the command line?

609


What is difference between server jobs & parallel jobs?

635


To see hidden files in LINIX?

950






How do u convert the columns to rows in datastage?

699


Where do the datastage jobs get stored?

741


Define APT_CONFIG in Datastage?

672


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1757


What are the components of datastage?

664


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1925


how can we create rank using datastage?what is the meaning of rank?

8199


Can you define merge?

674


whom do you report?

1512


What is the difference between passive stage and active stage?

834