How will you update the row without using update statergy?
Answer Posted / ganesh
1) If the target table doesn't have primary key, then using
update override we can update the records.
2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
can u give example for factless fact table
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is meant by active and passive transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can u generate reports in Informatica?
How might one distinguish in the case of mapping is right or not without associating session?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a grid in Informatica?
Scheduling properties,whats the default (sequential)
What is the advantage of informatica?
how to create user defined function (udf) in informatica
Can anyone tell me the new features in Informatica 9 Version?
Why update strategy and union transformations are active?
How to load the data from a flat file into the target where the source flat file name changes daily?