1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach

Answer Posted / rahul

In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.

Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will be the approach?

580


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

785


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

4310


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

709


What is a joiner transformation and why it is an active one?

580






What is data movement mode in Informatica and difference between them?

618


What are the differences between source qualifier and joiner transformation?

598


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?

1463


What are the designer tools for creating transformations?

685


How to use pmcmd utility command?

580


What is a surrogate key?

562


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1700


Performance tuning in UNIX for informatica mappings?

2139


Where is metadata stored?

623


What are the popular informatica products?

649