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 is the difference between mapplet & stored procedure?
How many ways you create ports?
Explain the different lookup methods used in informatica?
what are the settiings that u use to cofigure the joiner transformation?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is the exact difference b/w IN and EXIST in Oracle..?
What is a parameter When and where do you them when does the value will be created
In a concurrent batch if a session fails, can you start again from that session
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how