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 cleansing data
How to remove blank spaces from data?
What are routines in datastage? Enlist various types of routines.
what is time dimension? and how to populate time demension
how many rows sorted in sort stage by default in server jobs
what is data mapping
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What are the repository tables in datastage?
What is the difference between lookup and sparse lookup?
How many input links can you give to a Transformer stage?
how to configure databases through datastage