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.

Answers were Sorted based on User's Feedback



1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't ..

Answer / varma

Ans1 : We can use Read Method = “Specific Files” and give the full path of all the file one by one. Alternatively, you can use Read Method = “File Pattern” and specify the wild card.

Ans 2: We can control this using “Missing File Mode” Option. Values are “Ok” to skip the file and continue and “Error” to abort the job.

Ans3: It is important to make sure the meta data matches the record. It would be better to reject bad reject and collect them in “Reject Link”. This can be controlled by “Reject Mode” option. Values are “Continue”, “Fail” and “Output”. “Output” will collect the reject records in a reject link.

Is This Answer Correct ?    3 Yes 0 No

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't ..

Answer / 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

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't ..

Answer / 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

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't ..

Answer / 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

More Data Stage Interview Questions

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,


What are the prerequisites for join stage

2 Answers  


What is "fatal error/rdbms code 3996" error?

0 Answers  


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,


What is quality stage?

0 Answers  






which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,


Describe routines in datastage? Enlist various types of routines.

0 Answers  


I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  


hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  


how can we create tables in datastage?

1 Answers  


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,


Categories