Answer / mike

I think yes
for an unchached lookup table for every input roe the
lookup will query the lookup table to get the required rows.

HOpe this helps correct me if i was wrong

Answer / saif

uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.

Answer / akash

By default caching is not done by informatica, if we want
to use a cache in look up we must set the same in
properties..

Please correct me if I am wrong.

Answer / shrawan

I think we can use unconnected lookup.
Correct me If i am wrong.

Answer / ravikanth

using MD5 function we can achive this.

Answer / sbvp

my ans is wrong sorry
ans: yes why because they are two types of look up t/r are
there unconn/conn acutally .in that cache/uncahe look t/r's ok

Answer / sbvp

No,informatica server creates default index cache and data
cache. to evry transformations

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

How union transformation is used?

0 Answers  

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

what is scd?

6 Answers  

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

Clarify the utilization of aggregator cache record?

0 Answers  

what is dimension table?

17 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

what is lookupoverriding?

1 Answers  

What is staging area?

11 Answers