What is target update override
Answers were Sorted based on User's Feedback
Answer / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / usha
target update override which is used to update the data
with out using UPDATE transformation....
if there is no PK in the target we can update by using
target update override
| Is This Answer Correct ? | 1 Yes | 0 No |
While importing the relational source defintion from database,what are the meta data of source U import?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
In real time scenario where can we use mapping parameters and variables?
Explain direct and indirect flat file loading (source file type) - informatica
How to jion 2 tables, without using any condition?
What is a test load?
What is the maplet?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How can you increase the performance in joiner transformation?
What is the need of an ETL tool?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .