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

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

What is meant by active and passive transformation?

0 Answers  

Explain target update override in informatica

0 Answers   Informatica,

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

How to extract the informatica rejected data?

0 Answers  

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

0 Answers  

Which is the t/r that builts only single cache memory?

0 Answers  

Explain the flow of data in Iinformatica?

1 Answers  

can you use flat file for lookup table?why?

2 Answers   HCL,

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers