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

Answer Posted / bhupal

In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a flat file, want to reverse the contents of the flat file

918


Mention some types of transformation?

807


Enlist the various types of transformations.

751


Explain where to store informatica rejected data? How to extract the informatica rejected data?

830


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

881


Scheduling properties,whats the default (sequential)

1695


What is the use of transformation?

775


Explain pushdown optimization and types in informatica

863


Reusable transformation and shortcut differences

1597


Explian the Process of deployment groups in informatica

832


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2050


Describe an informatica powercenter?

817


Differentiate between a repository server and a powerhouse?

801


What is blocking transformation?

918


Differentiate between a database and data warehouse?

908