Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jagadish
update strategy transformation is used to perform DML
operations for the already data populated targets.
by default informatica server will treat source row as
INSERT.if you use update strategy transformation in your
mapping the informatica server will treat source row as
DATA DRIVEN.so the datas transferd to a target that even
populated with some data can be inserted,updated,rejected
and deleted.based upon the functions like
dd_insert,dd_update,dd_reject,dd_delete you define in the
update strategy transformation.
| Is This Answer Correct ? | 41 Yes | 3 No |
Post New Answer View All Answers
Is there any target staging area in informatica not staging area
generate date / time dimension in informatica
What is an Integration service in Informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the meaning of decode in informatica?
What is sequence generator transformation in informatica?
Name the different lookup cache(s)?
What is olap (on-line analytical processing?
Plz can any one say me how to get the informatica certification materials and dumps
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Make a note of the quantity vaults made in informatica?
What is a pre-defined event and user-defined event?
What are the features of complex mapping?
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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
