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
- 16591 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 expression transformation?
what are the Methods For Creating Reusable Transformations?
How are the sources and targets definitions imported in informatica designer?
How do you take back up of repository?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Differentiate between joiner and lookup transformation?
Difference between Target-based loading and constraint-based loading?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the code page compatibility?
What is a sorter transformation?
How to call shell scripts from informatica?
How to partition the Session?
what is index?how it can work in informatica
Differentiate between source qualifier and filter transformation?
