Question { 3771 }

Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?

Answer

In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)

Question { 3909 }

what are Lookup caches options? Including persistent caches.

Answer

There are two types of Lookup Cache options -

1. Dynamic cache.
2. Persistent cache

1. dynamic Cache - The Dynamic cache is a property of the
look up which if selected makes other ports of the same
record to be checked as Look up apart from the Look up port.

2. Persistent Cache - persistent cache is something like on
the first run the lookup table values gets into a cache and
is stored on the server's hard disk. Each time the run is
made the values would be looked up from this cache only.

Persistent cache is done only when the lookup has to be
made on same set of values each time.

Question { 5208 }

Is informatica power center designer has 64 bit support?

Answer

Yes it does.. :)

Question { TCS, 6585 }

How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.

Answer

A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.