Interested to Buy Any Domain ? << Click Here >> for more details...
what is target update override and when we use it?
- 2 Answers
- 6939 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.
Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
| Is This Answer Correct ? | 0 Yes | 0 No |
Why you use repository connectivity?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What is data movement mode in Informatica and difference between them?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What is Index Caches size?
Why we use partitioning the session in informatica?
What is update strategy transform?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
What is workflow? What are the components of the workflow manager?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can anyone tell me the new features in Informatica 9 Version?
Teradata 
