Interested to Buy Any Domain ? << Click Here >> for more details...
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 11022 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
describe the Steps to confiure a Qlogic switch
Where do you see different stages in the designer?
What are the types of containers and how to create them?
Differentiate between data file and descriptor file?
Can you highlight the main features of ibm infosphere information server?
What is the difference between informatica and datastage?
What are the some differences between 7.x and 8.x version of datastage?
What are constraints and derivations?
How do u convert the columns to rows in datastage?
Name the third party tools that can be used in datastage?
What are the important features of datastage?
Which warehouse using in your datawarehouse
Define oconv () and iconv () functions in datastage?
Terminate Activity
What are the different type of jobs in datastage?
