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
- 15906 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
What are the data movement modes in informatica?
How to elaborate tracing level?
How can we delete duplicate rows from flat files?
Where can we find the throughput option in informatica?
What is flashback table ? Advance thanks
Explain pushdown optimization and types in informatica
What is an active transformation?
How to generate sequence numbers using expression transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Is it possible to create multiple domains on a single Informatica server?
Describe expression transformation?
What is meant by incremental aggregation?
What is the scenario which compels informatica server to reject files?
Describe an informatica powercenter?
Why do you use Mapping Parameter and mapping variable?
