Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4875 Views
- Emphasis, I also Faced
- E-Mail Answers
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
Briefly define a session task?
Define update strategy?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between Active and Passive transformation?
Explain the informatica workflow?
What is informatica? Why do we need it?
How to extract sap data using informatica?
What are the mapping parameters and mapping variables?
Informatica settings are available in which file?
How to use pmcmd utility command?
Explain dynamic target flat file name generation in informatica
What is dimensional table? Explain the different dimensions.
Differentiate between source qualifier and filter transformation?
What do you mean by enterprise data warehousing?
What is the difference between writing a joiner query in ANSI style and THETA style?
