how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
Answers were Sorted based on User's Feedback
Answer / bsgsr
without using update t/mation also we can update. in
session properties select update against treat source rows
as. this wud definitely help you.
push down is a function of 8.1 version of informatica. it
reduces the load on informatica server.
unconnceted obviously bcoz not connected with the data flow
and uses only static cache.
also it can be called as many times in a mapping as a
result of an expession.
reach me on 9866188658.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / infa dev
Just using the Update override won't get your work done.
You will have to select the session property Treat source
rows as 'Update'
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
Answer / 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 |
Answer / sambasivarao.m
By using Update override option in Target table we can
update the table
Is This Answer Correct ? | 3 Yes | 9 No |
What are the basic needs to join two sources in a source qualifier?
whether Sequence generater T/r uses Caches? then what type of Cache it is
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
what is galaxy repository?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Explain the mapping variable usage example in informatica
How can you differentiate between powercenter and power map?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
What are the out put files that the informatica server creates during the session running?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is decode in static cache?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .