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
- 29677 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 |
Can we create Hierarchies in generic datasources?
What are various etl tools in the market?
what is the main role of FI on business
What is abap? What are idocs?
what is pmrep command?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is SMP AND MPP?
what are the data modeling tools you have used?(polaris)
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is the difference between OLTP database and data warehousing database?
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
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
Teradata 
