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 |
tell me abt Datastage trigger?
What is the use of surrogate key stage?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
what is the unix script to run the job? Please mention commands which we use often?
How to clean the datastage repository?
How to enter a log in auditing table whenever a job get finished?
how can u handle null values in transformer stage.
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
how many write modes are there in ds
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