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
- 9907 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
Explain the types of transformations?
What is sorter transformation?
What are the main issues while working with flat files as source and as targets ?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to load last n records of file into target table - informatica
What is meant by target load plan?
Can we create a Integration service without a Repository service and vice versa?
Clarify the aggregator change?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Enlist few areas or real-time situations where informatica is required.
What do you understand by SOA of Informatica?
Define filter transformation?
Why filter transformation is an active one?
What is xml source qualifier transformation in informatica?
What are the modules in Power Center
