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
- 16326 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 are the transformations that are not supported in mapplet?
Partition, what happens if the specified key range is shorter and longer
what is index?how it can work in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
What you know about transaction control transformation?
How to create or import flat file definition in to the warehouse designer?
Target increases every day even though no new record was inserted
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
draw informatica architecture 8.6 ?
What is the function of look up transformation?
What is the different lookup cache(s)?
How to differentiate between the active and passive transformations?
How can we use mapping variables in informatica? Where do we use them?
Can u generate reports in Informatica?
How can we remove the duplicates from flat file source?
