Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 26902 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijay
by using normaliser ransformation only you can convert the
rows to columns and vice versa
| Is This Answer Correct ? | 15 Yes | 12 No |
Answer / ramarao
Hi Friends,
I think this possible by using source Qualifier ALSO.
The Senario is
Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n
Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n
This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / sowjanya
Using BODS 3.2 or higher versions
To convert columns to Rows : PIVOT transform
To convert rows to coulums : REVERSE PIVOT transform
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / murugan
By using normalizer transformation we can use the conditions
only applied for row by columns..
by using the normalizer output we can use the function (first)
and then applied for conditions ..and then output will be
seen in column by rows....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mural
hi ramarao plz explain step by step
i am gettikng confusion
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pradeep sharma
this is easily achievable in talend also using the normalize and textract delimited field
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
i think we have to use macro function in build stage so we
have to write logic in macros but m not sure
| Is This Answer Correct ? | 1 Yes | 5 No |
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is different between sequential batch and concurrent batch and which is recommended and why?
What is etl tool in hadoop?
explain the methodology of Data Warehousing?(Polaries)
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What are materialized views & where do we use them?
Explain the use lookup tables and Aggregate tables?
how do u decide whether u need to do aggregations at database level or at Informatica level?
How to Check the source record count from traget table.
Difference between flat files and relational sources?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
What is initial load and what is full load?
Teradata 
