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
- 16230 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 the use of code page?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to update a particular record in target with out running whole workflow?
Clarify the aggregator change?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what is the Default Source Option For Update Strategy Transformation?
Explain the pipeline partition with real time example?
What is a connected transformation?
What are the popular informatica products?
Performance tuning in UNIX for informatica mappings?
Explain sessions?
What are connected or unconnected transformations?
What is the scenario which compels informatica server to reject files?
How do you load first and last records into target table?
COM components can be used in Informatica
