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 / 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 |
What are mapplets?
What is meta data and system catalog?
What is the capacity of power cube?
difference between informatica 8.1.1 and 8.6
Why do we use DSS database for OLAP tools?
How we can confirm all mappings in the repository simultaneously?
What is the difference between a shortcut of an object and copy of an object? Compare them.
without table how to come first record only in oracle?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
How would you copy the content of one repository to another repository?
What is persistent lookup cache?
What are the different threads in DTM process?