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
- 29776 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 |
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
what are the production issues in datastage?
what are the session parameters? How do u set them?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what is SMP AND MPP?
what is a worklet?
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 different Reporting and ETL tools available in the market?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
What are the names of the layers in etl?
What is etl process? How many steps etl contains?
how do u decide whether u need to do aggregations at database level or at Informatica level?
Teradata 
