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 is degenerated dimension?

3872

What is a filter transformation?

987

How to handle decimal places while importing a flatfile into informatica?

1130

Enlist few areas or real-time situations where informatica is required.

1020

Is stop and abort are same in informatica?

947

Explain target update override in informatica

1043

Differentiate between a database and data warehouse?

1090

What is source qualifier transformation in informatica?

947

Briefly describe lookup transformation?

982

Which transformation is needed while using the Cobol sources as source definitions?

1124

Explain sessions and how many types of sessions are there?

955

What does “tail –f” command do and what is its use as an Informatica admin.

1029

What is the difference between router and filter?

1153

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2021

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5683