Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / guest
yes,using target override property
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What is informatica worklet?
Reusable transformation and shortcut differences
How can you define user defied event?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist the differences between database and data warehouse.
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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is a snowflake schema?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Differentiate between reusable transformation and mapplet.
difference between repository database and repository service?
What is the Process to creating lookup transformation in informatica
How to update a particular record in target with out running whole workflow?