Interested to Buy Any Domain ? << Click Here >> for more details...
How we can convert rows to columns in datastage?
- 4 Answers
- 24936 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rams
Using pivot stage
ex:-
name,ph1,ph2
ramu,9849,9948
raja,9987,9967
touch,9898,0909
in pivoi stage go to output>- columns
columnname derivation
name
phone PH1,PH2
TO GOT THE RESULT IS
o/p:-
name phone
ramu,9849
ramu 9948
raja,9987
raja,9967
touch,9898
touch,0909
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What are the types of hashed files in data stage
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How do you import and export the datastage jobs?
What are the main features of datastage?
what is repositery?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the difference between orabulk and bcp stages?
Define Data Stage?
What are the functionalities of link partitioner and link collector?
options available in sequence job to run,validate?
How can we improve performance of data stage jobs?
How do you generate sequence number in datastage?
What are the functionalities of link collector?
What are the types of containers in datastage?
What is a merge in datastage?
