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
I have a flat file, want to reverse the contents of the flat file
Mention some types of transformation?
Enlist the various types of transformations.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
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?
Scheduling properties,whats the default (sequential)
What is the use of transformation?
Explain pushdown optimization and types in informatica
Reusable transformation and shortcut differences
Explian the Process of deployment groups in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Describe an informatica powercenter?
Differentiate between a repository server and a powerhouse?
What is blocking transformation?
Differentiate between a database and data warehouse?