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

What is the advantage of informatica?

0 Answers  

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

what are cost based and rule based approaches and what is the difference?

1 Answers  

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

Explain constraint based loading in informatica

0 Answers   Informatica,

Can we make worklet inside worklet?

1 Answers  

What is InformaticaPowerCenter?

0 Answers   Informatica,

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

How to configure mapping in informatica?

0 Answers  

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,