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
- 5638 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 do you generate sequence number in datastage?
How will you move hashed file from one location to another location?
How do y read Sequential file from job control?
What are the different type of jobs in datastage?
Where do you see different stages in the designer?
What is the purpose of interprocessor stage in server jobs?
What are the functionalities of link partitioner?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to export or import the jobs in .ISX file
How do you schedule or monitoring the job?
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 are the benefits of datastage?
Differentiate between datastage and informatica?
What are the features of datastage flow designer?
What a datastage macro?
