Interested to Buy Any Domain ? << Click Here >> for more details...
in datastage scenario this is sourec data i want this traget? tell me please?
source target
------- -------
Mohan,Prasad,Naresh Mohan
Prasad
Naresh
- 1 Answers
- 4296 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / datastage4you
Use Pivot stage
Thanks
www.datagenx.net
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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
What is use Array size in datastage
Is it possible to query a hash file?
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...
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the use of materialized view?
Why we use surrogate key?
What are routines in datastage? Enlist various types of routines.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between datastage and informatica?
What are the benefits of datastage?
What is active and passive stage?
Describe stream connector?
Can you explain engine tier in information server?
