How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)

Answer Posted / ramesh

this can achieved using Update statergy
we have option in UPD or Target update override

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is Active lock explain

2365


What is joiner change?

669


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1624


Target increases every day even though no new record was inserted

1103


What is a repository manager?

644






What are the different types of repositories created using informatica?

653


What are the features of complex mapping?

639


How do you remove duplicate records in informatica? And how many ways are there to do it?

711


What is the difference between informatics 7x and 8x and what is latest version?

539


What are the components of workflow manager?

584


Performance tuning( what you did in performance tuning)

1483


Define mapping and session?

581


While migrating the data from one environment to another environment how would you manage the connections?

623


scenario where i can use only concurrent execution of workflow.

2536


What is a pre-defined event and user-defined event?

577