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
what is degenerated dimension?
What is a filter transformation?
How to handle decimal places while importing a flatfile into informatica?
Enlist few areas or real-time situations where informatica is required.
Is stop and abort are same in informatica?
Explain target update override in informatica
Differentiate between a database and data warehouse?
What is source qualifier transformation in informatica?
Briefly describe lookup transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Explain sessions and how many types of sessions are there?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the difference between router and filter?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
-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?