HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 10447 Views
- IBM, I also Faced
- E-Mail Answers
SRC--->SORT--->TFM--->TGT
In the Sort Stage, mention the Sort Keys and Set
CreateKeyChangeColumn to TRUE. for each 1st of Key column,
value of the KeyChange column is '1' and for the duplicate
columns, value is '0'.
In the TFM Constraints, give constraint as 'KeyChange=0' and
set '1' for 'Abort After Rows' then the job will abort for 1st
duplicate record.
| Is This Answer Correct ? | 14 Yes | 0 No |
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
How rejected rows are managed in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
Describe routines in datastage? Enlist various types of routines.
Difference between JOIN,LOOKUP,MERGE?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
How to implement complex jobs in data stage?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
what is usage of datastage with materialized views
What is quality stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Teradata 
