how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
- 6 Answers
- 16328 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / usha
without using update transformation we can update by using
update overide if the target doent have a PK...
:TU
------------------------
push down operation in informatica means it will convert
transfromation logic to SQL query..
3 types..
source push down
target push down
full push down.
------------------------
connected lkp will give good prformence..
lookup gives more tuning performance
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
If informatica has its scheduler why using third party scheduler?
Could you explain what is enterprise data warehouse?
What is informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Where are the source flat files kept before running the session?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the sql query overwrite in source qualifier in informatica
What is event and what are the tasks related to it?
Why is sorter an active transformation?
What is the difference between router and filter?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to load the data from a flat file into the target where the source flat file name changes daily?
How to update or delete the rows in a target, which do not have key fields?
State the differences between sql override and lookup override?
