Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 14868 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sudhar
Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Is there any way to read the ms excel datas directly into informatica?
How can we update a record in the target table without using update strategy?
Difference between Target-based loading and constraint-based loading?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the different lookup cache(s)?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the limitations of joiner transformation?
Which files are created during the session rums by informatics server?
what is SDLC way of code development?
During the running session, output files are created by informatica server. Enlist few of them.
Informatica settings are available in which file?
In informatica workflow manager, how many repositories can be created?
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?
Briefly explain the aggregator transformation?
