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
- 4017 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
How many ways are there to create ports?
difference between informatica 8.1.1 and 8.6
What is the meaning of decode in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What do you understand by SOA of Informatica?
how many types of dimensions are available in informatica?
How union transformation is used?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the use of an aggregator cache file?
How do you remove duplicate records in informatica? And how many ways are there to do it?
During the running session, output files are created by informatica server. Enlist few of them.
How many numbers of sessions can one group in batches?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explian the Process of deployment groups in informatica
