how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anyone suggest best free Talend data integration training online

1263


How many input parameters can exist in an unconnected lookup?

1003


What is dimensional table?

625


Is it possible to use a client with different version than that of its Informatica server?

645


What are the new features of Power Center 5.0?

1234






In development project what is the process to follow for an etl developer from day1

1286


Briefly describe lookup transformation?

602


What is informatica?

686


What is data transformation manager process?

623


how we can load rejected record's at run time?(not through bad files)

1913


What are the different transaction levels available in transaction control transformation?

679


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1469


What is a shortcut and copy in Informatica and how two are different with each other?

688


Explain scd type 3 through mapping.

589


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4318