Interested to Buy Any Domain ? << Click Here >> for more details...
If we set dd_insert in mapping and Delete in session properties what will happen.?
- 4 Answers
- 8530 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / usha
It will perform delete.
because session properties overide mapping properties.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
What is a surrogate key?
How you prepared reports for OLAP?
What is union transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Quickly characterize reusable change?
How do you manage the Parameter files while migrating your data from one environment to another environment?
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
difference between repository database and repository service?
Please let me know how to make Data masking in informatica..
What is the difference between writing a joiner query in ANSI style and THETA style?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to generate sequence numbers using expression transformation?
Explain constraint based loading in informatica
