Interested to Buy Any Domain ? << Click Here >> for more details...
SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS
TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS
- 1 Answers
- 5525 Views
- I also Faced
- E-Mail Answers
Answer Posted / chethankumar km
using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How many types of hash files are there?
What is the difference between server job and parallel jobs?
How many types of sorting methods are available in datastage?
Triggers,VIEW,Procedures
What are the functionalities of link collector?
What is job control?
What are sequencers?
How one source columns or rows to be loaded in to two different tables?
Can you explain kafka connector?
What are the main features of datastage?
CHANGE CAPTURE
Enlist various types of routines in datastage.
How can you write parallel routines in datastage PX?
What are the areas of application?
What is merge stage?
