wht target override?wht advantages it has compare to target
update?
Answers were Sorted based on User's Feedback
Answer / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rkumar.etl
when table is having huge amount of records and performance
is the key factor to implement the target overrride ..if we
use update override it will take more time than the target
override.
Is This Answer Correct ? | 4 Yes | 3 No |
What is sql query override? When did u use sql query override?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
How do you remove duplicate records in informatica? And how many ways are there to do it?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is the Difference between PowerPlay transformer and power play reports?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is the Router transformation?
How does a rank transform differ from aggregator transform functions max and min?
How an expression transformation differs from aggregator transformation?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
How will the document be delivered to me?
My source table having some records ,i want load 1st record and last record into one target?