If we set dd_insert in mapping and Delete in session properties what will happen.?
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
State the differences between sql override and lookup override?
How many ways are there to do 'remove duplicate records in informatica'?
When do you use sql override in a lookup transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Can we override a native sql query within informatica?
Enlist the differences between database and data warehouse.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to do unit testing in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How can informatica be used for an organization?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can we update a record in the target table without using update strategy?