Answer Posted / yallu

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

Is it possible to use a client with different version than that of its Informatica server?

1075

---

What is a stored procedure transformation?

989

---

Explain Dataware house architecture .how data flow from intial to end?

2526

---

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

7629

---

What is meant by lookup transformation?

1034

---

What do you understand by term role-playing dimension?

982

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1085

---

What is an aggregator transformation?

1030

---

How can we update a record in the target table without using update strategy?

1087

---

How do you set a varible in incremental aggregation

1826

---

Explain load alternative records / rows into multiple targets - informatica

1099

---

What is a standalone command task?

1134

---

Explain how many types of dimensions are available in informatica?

1007

---

what is the -ve test case in your project.

2329

---