Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16855 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jhansi
YES,we can insert new rows and updat existing row
By setting Session level properties
1.Session->properties->TreatSourceRowas Update
2.Session->mapping->target properties->select update else
insert
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is difference between a gateway node and worker node?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Write the unconnected lookup syntax?
What are the reusable transformations?
Explain what transformation and how many are there in informatica?
Difference between Target-based loading and constraint-based loading?
What is dimensional table?
How can one identify whether mapping is correct or not without connecting session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How many ways are there to do 'remove duplicate records in informatica'?
What you know about transaction control transformation?
Explain what are the different versions of informatica?
What is the benefit of session partitioning?
What is a difference between complete, stop and abort?
What does “tail –f” command do and what is its use as an Informatica admin.
