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

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

Question Posted / ramesh

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

Please Help Members By Posting Answers For Below Questions

What are the components of Informatica? And what is the purpose of each?

1108

What is workflow monitor?

1102

What is source qualifier transformation in informatica?

1066

Explain target update override in informatica

1190

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2187

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1957

Explain in detail about scd type 1 through mapping.

1630

How many ways a relational source definition can be updated and what are they?

1068

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2110

What is meant by pre and post session shell command?

1202

list out all the transformations which use cache?

1242

What are the different types of olap? Give an example?

1098

What is the different lookup cache(s)?

1131

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1142

What is a filter transformation and why it is an active one?

1016