1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

what will happen if we allow duplicates in datastage lookup

abort
drop record
1st value of duplicate record
none

Question Posted / sonu


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

Answer / soumya

There will be a warning in log saying that a duplicate value occurs.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What could be a data source system?

0 Answers  

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

How to reverse the string using unix?

0 Answers   CTS,




I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

Difference between in process and inter process?

0 Answers  

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

What is a range lookup?

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories