how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
Answer Posted / infa dev
Just using the Update override won't get your work done.
You will have to select the session property Treat source
rows as 'Update'
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
how to load rows into fact table in data warehouse
How to go to the older version for a mapping?
what is Active lock explain
In which transformation you cannot drag ports into it?
How do you handle two sessions in Informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is DR strategy for Informatica project?
Write the prerequisite tasks to achieve the session partition?
How do you load only null records into target? Explain through mapping flow.
How to implement security measures using repository manager?
Can you generate sequence numbers without using the sequence generator transformation?
What is an aggregator transformation?
Explain your project of banking domian.
In warehouses how many schemas are there?