Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / sreedhar lokaray
Yes you can insert or update a table without using update
strategy. In the Mapping tab of the Session property go to
Target properties and check the attribute value Insert to
insert or check Update as Update to update.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse.
How can we improve session performance in aggregator transformation?
What are the advantages of informatica?
scenario where i can use only concurrent execution of workflow.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to implement security measures using repository manager?
How to create Target definition for flat files?
How might one distinguish in the case of mapping is right or not without associating session?
expain about the tune parameters?
In warehouses how many schemas are there?
How would you copy the content of one repository to another repository?
What are the main features of Oracle 8i with context to datawarehouse?
What is informatica? Why do we need it?
Is it possible to define a single node as a Gateway node as well as worker node?
Mention a few design and development best practices for informatica?