Insert else update option in which situation we will use
- 4 Answers
- 9783 Views
- HCL, I also Faced
- E-Mail Answers
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
How to create a non-reusable instance of reusable transformations?
What do think which one is the better joiner or look up?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the use of code page?
Which version configuration tool used in ur project?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is informatica powercenter repository?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Enlist the differences between database and data warehouse.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is rank transformation in informatica
What is the function of union transformation?
What are the types of caches in lookup?
What are the different clients of powercenter?
