Answer / rkumar.etl

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

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  

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

What do you mean by enterprise data warehousing?

0 Answers  

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

How do you take care of security using a repository manager

2 Answers  

---