If we set dd_insert in mapping and Delete in session properties what will happen.?
Answer Posted / insha
It will perform delete operation since session defines run
time properties of mapping
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are mapplets?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the meaning of decode in informatica?
tell me about your project functionality
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the procedure for creating independent data marts from informatica 7.1?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain constraint based loading in informatica
What is the sql query overwrite in source qualifier in informatica
Difference between Target-based loading and constraint-based loading?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the types of data warehouses?
What is the status code in stored procedure transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?