wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13232 Views
- Polaris, I also Faced
- E-Mail Answers
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 are set operators in Oracle
how may sources can be used in a mapping at a time?(limit)
When we are using Dynamic Cache,which options we will select in session level?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
In how many ways we can create ports?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Informatica and datawarehousing courses in Pune?
What are parallel querys and query hints?
Teradata 
