HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
Answer Posted / subhash
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 |
Post New Answer View All Answers
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the method of removing duplicates, without the remove duplicate stage?
What is the difference between datastage and informatica?
What are the types of containers in datastage?
Can you explain kafka connector?
What are the functionalities of link partitioner and link collector?
What is merge stage?
What are the various kinds of containers available in datastage?
Where do the datastage jobs get stored?
Why fact table is in normal form?
In Datastage, how you can fix the truncated data error?
What are routines in datastage?
Highlight the main features of datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is ibm datastage flow designer?