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
- 4948 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
What is the sequence generator transformation in informatica?
How to open an older version of an object in the workspace?
How can we remove the duplicates from flat file source?
What is aggregate cache in aggregator transformation?
What is dimensional table? Explain the different dimensions.
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
How to do unit testing in informatica? How to load data in informatica ?
What are the guidelines to be followed while using union transformation?
What is Session and Batches?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Design a mapping to load a target table with the following values from the above source?
Explain direct and indirect flat file loading (source file type) - informatica
permutations of mapplet
scenario where i can use only concurrent execution of workflow.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
