Interested to Buy Any Domain ? << Click Here >> for more details...
can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 16852 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain pushdown optimization and types in informatica
How big was your fact table
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
have u done any performance tuning? how u ll do?
What all are steps in up gradation of Informatica server?
How many ways a relational source definition can be updated and what are they?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain why we use partitioning the session in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is intricate mapping?
What is meant by lookup transformation?
What is workflow monitor?
How might one distinguish in the case of mapping is right or not without associating session?
Enlist the various types of transformations.
