Insert else update option in which situation we will use

Answer Posted / madhavi

if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name at least 5 different types of transformations used in mapping design and state the use of each.?

888


Explain the shared cache and re-cache?

807


How can repository reports be accessed without sql or other transformations?

944


Write the prerequisite tasks to achieve the session partition?

829


How to improve the performance of a session using sorter transformation?

905


Can we override a native sql query within informatica?

808


What is dimensional table?

792


How to use pmcmd utility command?

768


What are the new features of informatica 9.x developer?

731


How do you update the records with or without using update strategy?

865


Explain pushdown optimization $pushdownconfig parameter - informatica

901


explain about unit testing? in real time?

1891


What is meant by query override?

824


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2125


How many dimensions are there in informatica?

820