Answer Posted / sarun5

It is BI tool used for reporting purposes.

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?

10313

---

How you prepared reports for OLAP?

1655

---

can u any challenge your project?

2083

---

What are the new features of Power Center 5.0?

1846

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1301

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6280

---

What is aggregate cache in aggregator transformation?

1198

---

What are the different ways to implement parallel processing in informatica?

1479

---

What is informatica powercenter repository?

1254

---

tell me 5 session failure in real time how can you solve that in your project?

2388

---

waht type of interface is used for testing the data in informatica

2295

---

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

1137

---

What is union transformation in informatica?

1189

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2190

---

what is unit testing?tell me proceedure

2272

---