Interested to Buy Any Domain ? << Click Here >> for more details...
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 10801 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 are the main differences you have observed between 7.x and 8.x version of datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is a datastage job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
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...
Triggers,VIEW,Procedures
Is it possible to query a hash file?
What is the purpose of pivot stage and types of containers in datastage
What are the types of containers in datastage?
what is the difference between == and eq in UNIX shell scripting?
How do you generate sequence number in datastage?
State the difference between an operational datastage and a data warehouse?
Define oconv () and iconv () functions in datastage?
What is the different type of jobs in datastage?
What is a ds designer?
