there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?
Answer Posted / gm
Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET
In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner?
How are indexes created after completing the load process?
What is data caches/ index caches?
What is native users?
Explain how to import oracle sequence into informatica?
In how many ways we can create ports?
what is $$$$?
What do you mean incremental aggregation?
Explain about Informatica server process that how it works relates to mapping variables?
What do you mean by worklet?
Why update strategy and union transformations are active?
Explain your project of banking domian.
What is meant by lookup transformation?
Repository user profiles
Do you find any difficulty while working with flat files as source and target?