Answer Posted / chanakya123

Hi, Using UNION ALL ,You can achieve it, here is Your Query

SELECT 'JAN' AS MONTH, SUM(JAN) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'FEB' AS MONTH, SUM(FEB) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'MAR' AS MONTH, SUM(MAR) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'APR' AS MONTH, SUM(APR) AS TOTAL FROM SRC_MONTHS

Thanks
Kalyan Sankuthula

What are the different types of repositories created using informatica?

1128

---

Enterprise data warehouse your projects phase by phase explain?

1918

---

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?

10167

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8201

---

Separate from a database, an information bazaar, and an information stockroom?

1087

---

What are the tasks that can be performed using sq?

1091

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2394

---

Explain what is informatica metadata and where is it stored?

1049

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1165

---

How might you approve all mappings in the archive all the while?

1017

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1289

---

Whats there in global repository

1692

---

How can we update a record in the target table without using update strategy?

1144

---

What is a connected transformation?

1113

---

How to configure mapping in informatica?

1173

---