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
What are three tier systems in etl?
What are the three tiers in etl?
Explain and compare etl & manual development?
What is the difference between Data Warehousing and Data Mining?
what is the difference between cardinality and Nullability?
What is grain of fact?
Explain about the data integration suite features?
what is the use of structures?how many nodes can u create in a structure?
what are the reporting tools and difference between them?
how do u really know that paging to disk is happening while u are using a lookup transform?
Define slowly changing dimensions (SCD)?
explain the methodology of Data Warehousing?(Polaries)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
what is the difference between cardinality and Nullability?
how would u estimate the size of Lookup transform data and index cache?