Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 26929 Views
- Infosys, I also Faced
- E-Mail Answers
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 the different etl testing categories as per their function?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is cube grouping?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Compare ETL & Manual development?
What are the three tiers in etl?
how would u estimate the size of Aggregator transform data and index cache?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain what is etl process? How many steps etl contains explain with example?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how to load the data to fact table?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
SCD2 will work on only dimension tables as well as fact Table?
What is fact? What are the types of facts?
