Answer Posted / yallu

Types of lookup caches :
1.persistant cache
2.static cache
3.dynamic cache
4.shared cache
5.recache from source

What is a filter transformation and why it is an active one?

970

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2081

---

What is transformation?

1105

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2342

---

How do you handle two sessions in Informatica

1171

---

What is primary and backup node?

1136

---

Slowly changing dimensions, types and where will you use them

1717

---

What is sequence generator transformation in informatica?

1081

---

define galaxy repository in informatica

2232

---

How to generate sequence numbers using expression transformation?

1094

---

What is substr in informatica?

1211

---

What does command task mean?

1155

---

What is an unconnected transformation?

1088

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1060

---