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
- 17669 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
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 is the difference between Active and Passive transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
difference between source based commit? and target based commit? which is better with respect to performance?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Can we insert ,update ,delete in target tables with one update strategy tran.?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
difference between shortcut and reusable transformation?
how to load dimension table and fact table. plz tell me the steps.
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is fact table? Explain the different kinds of facts.
Teradata 
