Answer Posted / prakash chandran

Row To columns
--------------

Use Normalizer Transformation


Column To Rows
--------------

SOURCE
------
ENO COL_HDR COL_VAL
------------------------
1 ENAME PRAKASH
1 ESAL 35000
2 ENAME SREE
2 ESAL 25000

OUTPUT
------
ENO ENAME ESAL
1 PRAKASH 35000
2 SREE 25000

MAPPING LOGIC
--------------

SRC -----> AGG -----> TGT

Use First Function in Aggegrator to convert the Column to
rows

In Aggegrator, Create two output columns and write the
following expression

Port Name Expression
--------- ----------
O_ENAME FIRST(COL_VAL,COL_HDR='ENAME')
O_ESAL FIRST(COL_VAL,COL_HDR='ESAL')

Please get back to me in case of queries.

Thx & Regards,
Prakash Chandran

what is pmrep command?

2363

---

What are dimensions?

983

---

Explain the difference between etl tool and olap tools?

848

---

What is a staging area? What is the purpose of a staging area?

824

---

how many maximum session supports to multiload in teradata ??

2039

---

tell me few points when u become TL

2455

---

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2566

---

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2178

---

what is the main role of FI on business

2030

---

How to increase performance without changing anything in mapping.( In prod)

1200

---

What are the types of Data Warehouse applications?

934

---

Compare etl & elt?

946

---

What is meant by incremental load?

1014

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1479

---

What is cube grouping?

991

---