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.

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

What do mean by local and global repository?

0 Answers  

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

What is the use of code page?

0 Answers  

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---