Interested to Buy Any Domain ? << Click Here >> for more details...
In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?
- 3 Answers
- 7863 Views
- emc2, I also Faced
- E-Mail Answers
Answer Posted / aswin
its all depending on "treat source rows as" option in session level..if we have "data driven" option selected, the Integration service look for update strategy options (DD_INSERT, DD_UPDATE, DD_REJECT, DD_DELETE)
in the above question if DD_INSERT given in UPD and delete is choosen in target property and "Data driven" option is selected then - integration service will reject the row since all rows marked for insert in the mapping level
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is status code in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain lookup transformation is active in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
What are the prerequisite tasks to achieve the session partition?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a standalone command task?
Explain the shared cache and re-cache?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain the use of aggregator cache file?
What do mean by local and global repository?
Explain the difference between mapping parameter and mapping variable?
How do you load alternate records into different tables through mapping flow?
Can u generate reports in Informatica?
