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
- 15910 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
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How we can use union transformation?
Explain scd type 3 through mapping.
Explain sessions and how many types of sessions are there?
Differentiate between a repository server and a powerhouse?
What are session parameters ? How do you set them?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the advantages of informatica?
Which development components of informatica have the highest usage?
How we can create indexes after completing the load process?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Define enterprise data warehousing?
How to update or delete the rows in a target, which do not have key fields?
What is an Integration service in Informatica?
How to generate sequence numbers without using the sequence generator transformation?
