How we can convert rows to columns in datastage?
- 4 Answers
- 24009 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manohar palla
I am going to use tranformer and funnel stages to implement the
pivot functionality.
name ph1 ph2---> tranformer--->tf1 name ph1
| funnel---->o/p
|____>tf2 name ph2
tf1 and tf2 are the TWO links from transfomer..
in tf1 we have the name and ph1 where in tf2 name and ph2.
In funnel stage i am going to club the two links and send it
to o/p.
Thanks :)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is active and passive stage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Difference between in process and inter process?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you define merge?
what is flow of project?
how to sort two columns in single job in datastage.
Define ds designer?
What are iconv and oconv?
Where the datastage stored his repository?
How to reverse the string using SQL?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Can you explain engine tier in information server?
