Answer Posted / g. manthiramoorthy

1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables

What is the fact table?

993

---

Explain what are the different types of transformation available in informatica.

1038

---

What is the different lookup cache(s)?

1034

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9972

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1908

---

How do you convert single row from source into three rows into target?

1091

---

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 the different lookup cache(s)?

1158

---

What is aggregator transformation in informatica?

896

---

What is the use of source qualifier?

1070

---

what is index?how it can work in informatica

1980

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2313

---

How to do unit testing in informatica?

1122

---

What is update strategy transform?

1015

---

Sequence generator, when you move from develoment to production how will you reset

1940

---