what will happen if we allow duplicates in datastage lookup

abort
drop record
1st value of duplicate record
none



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 is RCP?

2 Answers   TCS,


I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,


Name the command line functions to import and export the DS jobs?

0 Answers  


source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


What are transforms and what is the differenece between routines and transforms?

0 Answers  






how can we create tables in datastage?

1 Answers  


Nls stands for what in datastage?

0 Answers  


what is parameterset?

4 Answers   Wipro,


what is the use of skid in reporting?

0 Answers   NTT Data,


I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,


1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,


what is mapping lookup

1 Answers  


Categories