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

3 Answers   CTS, Wipro,

---

How to start a workflow using pmcmd command?

0 Answers  

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

what is session parameters?

1 Answers   Cap Gemini,

---

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

---

---

What is deployment group?

0 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What do you mean by enterprise data warehousing?

0 Answers  

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

Explain the aggregator transformation?

0 Answers  

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---