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
Explain the situation where you have applied SCD in your project?
How to RD using transformer?
Define orabulk and bcp stages?
What are the benefits of datastage?
Difference between server jobs & parallel jobs?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the partitioning techniques available in link partitioner?
What is the purpose of pivot stage?
Nls stands for what 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)
Define Data Stage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How one source columns or rows to be loaded in to two different tables?
What are the features of datastage flow designer?
What is staging variable?