what will happen if we allow duplicates in datastage lookup
abort
drop record
1st value of duplicate record
none
Answer Posted / 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 View All Answers
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain connectivity between datastage with datasources?
Difference between server jobs & parallel jobs?
What are stage variables, derivations and constants?
In Datastage, how you can fix the truncated data error?
How to manage date conversion in Datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
options available in sequence job to run,validate?
What are the primary usages of datastage tool?
What are the various kinds of containers available in datastage?
Give an idea of system variables.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the project in datastage?
what is ds administrator used for?