how we can update a target table without update strategy and
update override?

Answer Posted / moorthy g

In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can informatica load heterogeneous targets from heterogeneous sources?

697


without table how to come first record only in oracle?

1858


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5584


What is the advantage of informatica?

650


What is the use of code page?

610






What is data movement mode in Informatica and difference between them?

624


Write the advantages of partitioning a session?

748


How would you copy the content of one repository to another repository?

559


What are the different types of repositories created using informatica?

663


How to do unit testing in informatica?

722


What are the different types of olap? Give an example?

564


What is confirmed fact in dataware housing?

5693


How to convert multiple rows to single row (multiple columns) in informatica

899


Explain the use of aggregator cache file?

678


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640