Interested to Buy Any Domain ? << Click Here >> for more details...
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 10839 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
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How do u convert the columns to rows in datastage?
Triggers,VIEW,Procedures
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is ibm datastage?
How to read the length of word in unix?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are system variables and sequencers in datastage
What are the some differences between 7.x and 8.x version of datastage?
How do you import and export the datastage jobs?
How can one find bugs in job sequence?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the various kinds of the hash file?
How to read multiple files using a single datastage job if files have the same metadata?
What is job control?
