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



how can we update without using update transformation. wt is push down operation in informatica. w..

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

how can we update without using update transformation. wt is push down operation in informatica. w..

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

how can we update without using update transformation. wt is push down operation in informatica. w..

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

how can we update without using update transformation. wt is push down operation in informatica. w..

Answer / gyana

GOOD WORK USHA

Is This Answer Correct ?    0 Yes 0 No

how can we update without using update transformation. wt is push down operation in informatica. w..

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

how can we update without using update transformation. wt is push down operation in informatica. w..

Answer / sambasivarao.m

By using Update override option in Target table we can
update the table

Is This Answer Correct ?    3 Yes 9 No

Post New Answer

More Informatica Interview Questions

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


What are the types of maping in Getting Started Wizard?

1 Answers  


What is resilience time?

0 Answers  


What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,


SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


What are the tasks that source qualifier performs?

1 Answers  


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,


How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


Explain what transformation and how many are there in informatica?

0 Answers  


What do you mean by blocking transformation?

0 Answers  


Categories