Interested to Buy Any Domain ? << Click Here >> for more details...
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 10889 Views
- IBM, I also Faced
- E-Mail Answers
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 ibm datastage flow designer?
To see hidden files in LINIX?
What are transforms and what is the differenece between routines and transforms?
What can we do with datastage director?
Where do the datastage jobs get stored?
How do u convert the columns to rows in datastage?
how to abort the job its matain duplicates?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How can you write parallel routines in datastage PX?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Why do we use link partitioner and link collector in datastage?
What is the use of datastage director?
State the difference between an operational datastage and a data warehouse?
table actions available in oracle connector?
