Interested to Buy Any Domain ? << Click Here >> for more details...
Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 29387 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
How many types of transformations supported by sorted input?
In Which Transformation We Can Use Having Clause In Informatica?
what is the difference between cardinality and Nullability?
what is an ETL or ETT? And what are the different types?
What is tracing level and what are the types?
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
what is the use of server?
how many maximum session supports to multiload in teradata ??
Do we need an ETL tool? When do we go for the tools in the market?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is the difference between round-robin partitioning and hash partitioning?
What is meant by incremental load?
What are the steps involved in etl process?
what are Lookup caches options? Including persistent caches.
What is etl tool in hadoop?
