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
- 10237 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
Differentiate between sessions and batches?
What are multi-group transformations?
What is workflow? What are the components of workflow manager?
Enlist some properties of sessions.
Suppose we do not group by on any ports of the aggregator what will be the output?
Define mapping and session?
How to create or import flat file definition in to the warehouse designer?
How to use procedural logic inside infromatica?
What can we do to improve the performance of informatica aggregator transformation?
Explain direct and indirect flat file loading (source file type) - informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is expression transformation?
How to update source definition?
What is a passive transformation?
In how many ways we can create ports?
