Which type or t/s is used to convert rows into column &
column into rows

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

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are three tier systems in etl?

718


What are the three tiers in etl?

685


Explain and compare etl & manual development?

601


What is the difference between Data Warehousing and Data Mining?

651


what is the difference between cardinality and Nullability?

2924






What is grain of fact?

621


Explain about the data integration suite features?

560


what is the use of structures?how many nodes can u create in a structure?

1856


what are the reporting tools and difference between them?

1667


how do u really know that paging to disk is happening while u are using a lookup transform?

1643


Define slowly changing dimensions (SCD)?

718


explain the methodology of Data Warehousing?(Polaries)

1561


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1427


what is the difference between cardinality and Nullability?

2594


how would u estimate the size of Lookup transform data and index cache?

1745