Answer Posted / sudheer

The main thing Merging of data is nothing but integrating from multiple source systems. It is in 2 types
1.Horizontal merging(Join)
2.Vertical Merging(Union)

Differentiate between joiner and lookup transformation?

1048

---

What is an Integration service in Informatica?

1081

---

What is workflow manager?

988

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1027

---

is it possible to index the data in cache of lkp transformation ?

1959

---

What is Index Caches size?

1054

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1991

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1894

---

What are the components of the workflow manager?

1079

---

Explain about cumulative Sum or moving sum?

976

---

What do you mean by filter transformation?

902

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7114

---

What are the guidelines to be followed while using union transformation?

1064

---

What is the function of look up transformation?

1054

---

In informatics server which files are created during the session rums?

1063

---