what is meant by lookup caches?
Answers were Sorted based on User's Feedback
Answer / swetha
The informatica server builds a cache in memory when it
processes the first row af a data in a cached look up
transformation. It allocates memory for the cache based on
the amount you configure in the transformation or session
properties. The informatica server stores condition values
in the index cache and output values in the data cache.
| Is This Answer Correct ? | 15 Yes | 2 No |
What is a unit Testing?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Performance tuning( what you did in performance tuning)
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what is the dashbords?
Did u used latest transformations of 8.6.0? for what?
Enlist the tasks for which source qualifier transformation is used.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
how can i invoke pmcmd in command line prompt
Which are the different editions of informatica powercenter that are available?
What is Java Transformation? what are the uses of it?