without dynamic lookup transformation how to insert new
rows and update existing rows?
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
How to update a particular record in target with out running whole workflow?
What is depict expression change?
What is mapplet in informatica?
How do you set a varible in incremental aggregation
What are the reusable transformations?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to extract sap data using informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is the way to execute pl/sql script using informatica mapping?
What is the difference between stop and abort in informatica
How big was your fact table
In informatics server which files are created during the session rums?
How can you validate all mappings in the repository simultaneously?
What are the different clients of powercenter?
Performance tuning in UNIX for informatica mappings?