how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.

Answer Posted / sambasivarao.m

By using Update override option in Target table we can
update the table

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

r u done any partitions in ur project?

1563


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1405


What is target designer and target load order?

841


Do you find any difficulty while working with flat files as source and target?

864


Design a mapping to load the cumulative sum of salaries of employees into target table?

1174


What is a passive transformation?

815


What is domain and gateway node?

916


Clarify the aggregator change?

771


What are the new features of informatica 9.x developer?

731


What is sq transformation?

846


Can informatica load heterogeneous targets from heterogeneous sources?

929


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1540


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

965


How does a sorter cache works?

770


Write the program through which the records can be updated?

729