Interested to Buy Any Domain ? << Click Here >> for more details...
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
- 1 Answers
- 10931 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
Why do we use exception activity in Datastage?
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
Differentiate between operational datastage (ods) and data warehouse?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how to implement scd2 in datastage 7.5 with lookup stage
What is apt_config in datastage?
Describe stream connector?
What is the precedence of stage variables,derivations, and constraints?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is process model?
Define Job control?
Does datastage support slowly changing dimensions ?
To see hidden files in LINIX?
Define meta stage?
