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 is partitioning? Explain about round-robin, hash partitioning.
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
How to fine tune mappings?
what is granularity in Data ware House?
What is Data Vault???
how to connect to a flatfile through ftp in informatica
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 ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is the difference between project backlog and product backlog?
what is the main role of FI on business
Define Dynamic push down optmization?
What do you understand by active and passive transformations?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what is Forward,Reverse and Re_engineering?
can cubes contain measures ?