How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 8347 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
Mention few power centre client applications with their basic purpose?
How to do the error handling of if ur source is flatfiles?
Enlist the tasks for which source qualifier transformation is used.
How to extract the informatica rejected data?
Explain the types of transformations?
Name the different lookup cache(s)?
What is informatica powercenter repository?
What is resilience time?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Write the prerequisite tasks to achieve the session partition?
What are the different transaction levels available in transaction control transformation?
How to extract sap data using informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain your project of banking domian.
