how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / 24/12/2007

if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to extract sap data using informatica? What is abap? What are idocs?

560


What is flashback table ? Advance thanks

1482


What is Session and Batches?

666


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

720


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1650






Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485


What is the benefit of partitioning a session?

633


How would you copy the content of one repository to another repository?

561


What are the static cache and dynamic cache in informatica?

721


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

606


Explain how many types of dimensions are available in informatica?

598


What are the guidelines to be followed while using union transformation?

643


Explain in detail about scd type 1 through mapping.

593


Why do you use Mapping Parameter and mapping variable?

1290


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

621