Answer Posted / suresh

java transformation and Sql transformation only in
implemented in 8.6.0

Explain informatica architecture - version 8 / 9

1090

---

What do you understand by term role-playing dimension?

1048

---

What do mean by local and global repository?

1226

---

Which transformation should we use to normalise the COBOL and relational sources?

1209

---

What are the advantages of using informatica as an etl tool over teradata?

1022

---

Explain the pipeline partition with real time example?

1144

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1505

---

What is joiner transformation?

1010

---

Does an informatica transformation support only aggregate expressions?

1042

---

What are session parameters ? How do you set them?

1850

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1961

---

Enlist the advantages of informatica.

1068

---

Differentiate between reusable transformation and mapplet.

1095

---

How many ways are there to do 'remove duplicate records in informatica'?

1014

---

How can one identify whether mapping is correct or not without connecting session?

1451

---