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
- 14645 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sudhar
Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Tell me about MD5 functions in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
Describe the impact of several join conditions and join order in a joiner transformation?
What is exclusive and normal mode for repository services?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Mention a few design and development best practices for informatica?
Explain sessions and how many types of sessions are there?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to convert multiple rows to single row (multiple columns) in informatica
Explain why we use partitioning the session in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is main use of mapplet?
Describe data concatenation?
What is depict expression change?
