Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 15059 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sailu
Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is domain in terms of informatica?
What is a transaction control transformation?
What are the new features of informatica 9.x developer?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to call shell scripts from informatica?
How to create Target definition for flat files?
how many types of dimensions are available in informatica?
what is informatica metadata?
Did u used latest transformations of 8.6.0? for what?
What is informatica? Why do we need it?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the need of etl tools?
Differentiate between source qualifier and filter transformation?
How you can differentiate between connected lookup and unconnected lookup?
