Yes you can insert or update a table without using update strategy. In th

Can we insert and update a target table without using update
strategy transformation?How?

Question Posted / sreedhar lokaray

4 Answers
23166 Views
Syntel, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain the different lookup methods used in informatica?

975

Parameter and variable differences

2006

Explain transaction control transformation in informatica

1213

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1849

Clarify the aggregator change?

972

How to create the source and target database connections in server manager?

1036

how tokens will generate?

2156

How do you set a varible in incremental aggregation

1828

Briefly describe lookup transformation?

982

What is the use of transformation?

947

What is the difference between router and filter?

1155

In warehouses how many schemas are there?

1010

What are the guidelines to be followed while using union transformation?

1066

What is the use of target designer?

983

Is there any way to read the ms excel datas directly into informatica?

980