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 difference between a table and the materialized view?

2 Answers  

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

what is mapping optimization? wat are the techniques for tat

2 Answers  

Explain sessions?

0 Answers  

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers