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
What are the different ways to implement parallel processing in informatica?
What are the new features of informatica 9.x developer?
What is decode in informatica?
Explain the mapping variable usage example in informatica
What is the reusable transformation?
What are ETL Tools?
Which are the different editions of informatica powercenter that are available?
How can we improve session performance in aggregator transformation?
Explain why we use partitioning the session in informatica?
Explain sql transformation in script mode examples in informatica
How can we remove the duplicates from flat file source?
What is update strategy transform?
How identifying bottlenecks in various components of informatica and resolving them?
What is resilience time?
What are the different components of powercenter?