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 |
how to convert rows into columns
What is difference between symmetric multiprocessing and massive parallel processing?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
How to enter a log in auditing table whenever a job get finished?
why we use hash file for lookup?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
How to remove blank spaces from data?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.