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.

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

How can we create index after completion of load process?

0 Answers  

---

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

what is mapping optimization? wat are the techniques for tat

2 Answers  

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---