Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17393 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 is sorter transformation?
Can we create two repositories on same database instance in oracle?
what is unit testing?tell me proceedure
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
In informatics server which files are created during the session rums?
what are factless facts? And in which scenario will you use such kinds of fact tables.
have u done any performance tuning? how u ll do?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is the hint? how to use it to reduce the query processing in program?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How many numbers of sessions can one group in batches?
What is a filter transformation?
What is the fact table?
What you know about transaction control transformation?
How to use procedural logic inside infromatica?
