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
- 16340 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / ashwin
We can use update override in the target table in mapping.
Push Down Optimization is an optimizing technique in
informatica 8. Integration service pushes the transformation
logic either to the source database or to the target
database rather than executing the logic by itself.
I think dynamic lookup gives a better performance since it
allows us to tune the cache sizes(index and data).
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What does cheating measurement mean?
What is the difference between informatica 7.0 and 8.0?
What is exclusive and normal mode for repository services?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a node in Informatica?
Explain in detail scd type 2 through mapping.
How do you change a non-reusable transformation to reusable transformation?
is it possible to index the data in cache of lkp transformation ?
What is a connected transformation?
What are session parameters ? How do you set them?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain lookup transformation in informatica
Where are the source flat files kept before running the session?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What does command task mean?
