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

Answer Posted / kareem

Here no one is understanding the question properly,In which
scenario we will go for static or dynamic lookup cache?

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate row using informatica?

606


How to open an older version of an object in the workspace?

616


Design time, run time. If you don't create parameter what will happen

1424


Where are the source flat files kept before running the session?

624


What is the need of an ETL tool?

640






Slowly changing dimensions, types and where will you use them

1271


Can you use flat files in Mapplets.

2217


What is rank index in rank transformation?

603


Differentiate between reusable transformation and mapplet.

570


Describe expression transformation?

636


Explain the tuning lookup transformation - informatica

611


What are the tuning techniques you applied during your last project

1561


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5570


Explain sessions. Explain how batches are used to combine executions?

593


How do you load unique records into one target table and duplicate records into a different target table?

707