what will happen if we allow duplicates in datastage lookup
abort
drop record
1st value of duplicate record
none
Answer / soumya
There will be a warning in log saying that a duplicate value occurs.
| Is This Answer Correct ? | 5 Yes | 0 No |
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
How can we improve the performance in datastage?
What is difference between server jobs & parallel jobs?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
In one project how many shared containers are created?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
What is a datastage job?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
count number of deptno in a emp table?