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
What is sq transformation?
How do you load unique records into one target table and duplicate records into a different target table?
what is SDLC way of code development?
Define joiner transformation?
Where is metadata stored?
Is stop and abort are same in informatica?
What is domain in terms of informatica?
What is workflow? What are the components of workflow manager?
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?
How can you differentiate between powercenter and power map?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to load the data from a flat file into the target where the source flat file name changes daily?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
can u any challenge your project?
In development project what is the process to follow for an etl developer from day1