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
- 29393 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 |
what happens if the info.server doesn't find the session parameter in the parameter file?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what are the data modeling tools you have used?(polaris)
What is a mapping, session, worklet, workflow, mapplet?
what are the concerns of OLTP and DSS systems?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
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 ?
How to fine tune mappings?
how would u estimate the size of Lookup transform data and index cache?
Difference between flat files and relational sources?
what is session partitioning?
What are the various tools used in etl?
Teradata 
