Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 9841 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / moorthy g [ibm]
1. Target Update Override
2. Select Unique Value (means)
Exp:
out_flag: decode( true, pre_no=no, 'Y', 'N')
pre_no = no
Router:
Out_flag: Y --- Unique Value
Default --- Duplicate Value
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the features of complex mapping?
What are mapplets?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of lookup transformation?
Scheduling properties,whats the default (sequential)
What is an aggregator transformation?
How will the document be delivered to me?
What do you mean by channel change?
How do you take back up of repository?
Enterprise data warehouse your projects phase by phase explain?
What are the limitations of joiner transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What differs when we choose the sorted input for aggregator transformation?
Quickly characterize reusable change?
