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

Sequence generator, when you move from develoment to production how will you reset

1412

Briefly define a session task?

595

What is lookup transformation?

605

What is sq transformation?

670

Describe an informatica powercenter?

609

explain abt ur project architecture?

1765

What are the main features of Oracle 8i with context to datawarehouse?

1685

What is informatica worklet?

614

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

641

What is the use of transformation?

578

What is the fact table?

595

list out all the transformations which use cache?

693

Have you worked with/created Parameter file

1232

What is native users?

725

How can you increase the performance in joiner transformation?

715