Answer / rajendra

Static:It is the tempoarary data to store
we cant update during the loading time
Dynamic:we update the during the data loading

Answer / nagaraju bhatraju

Uncached lookup: The informatica server doesnot build a
cache for temporary starage of data. Wenever it need to
refer to the look up table, it scans the source directly.

Dynamic Cache: The informaatica server builds a cache of
the source wen the workflow runs for the first time and it
updates the cache records dynamically after each row it
loads to the target. Means, if a target row gets updated,
the dynamic cache also gets updated automatically after
that particular row comitted in the target.

or
Dynamic cache - can be configured as connected lookup only.
It does not support lookup on flat file. Can have only
equality operator in lookup condition.

Static cache - can be configured as connected as well as
unconnected lookup. Supports lookup on flatfile. Can have
any relational operator in lookup condition.

Answer / deepthi

there is a correction in dynamic cache: 3rd point

dynamic cache can be used to unconnected tr.provided
unconnected lkp based on relational type.

Answer / deepthi

static cache:

1.static cache remains same during the session run
2.static can be used to relational and falt file lookup
types
3.static cache can be used to both unconnected and
connected lookup transformation
4.we can handle multiple matches in static cache
5.we can use other than relational operators like <,>,<=,>=
&=

Dynamic cache:

1.dynamic cache changes durig session run
2.dynamic cache can be used to only relational lookup types
3.Dynamic cache can be used to only connetced lookups
4.we cannot multiple matches in dynamic cache
5.we can use only = operator with dynamic cache.

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

---

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

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,

---

All active transformations r passive or not?

7 Answers  

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---