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
- 16637 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
How is union transformation utilized?
How to Create a folder using pmrep command?
Explain what are the different types of transformation available in informatica.
What are the different versions of informatica?
When do you use sql override in a lookup transformation?
Please let me know how to make Data masking in informatica..
What is the use of transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
how tokens will generate?
What is a joiner transformation?
Design time, run time. If you don't create parameter what will happen
Explain pushdown optimization and types in informatica
Write the unconnected lookup syntax and how to return more than one column.
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?
