SOURCE
CITY NAME1 NAME2 NAME3 NAME4
BGLR HCL CSC IBM TCS
TARGET
CITY COMPANY
BGLR HCL
BGLR CSC
BGLR IBM
BGLR TCS
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
Triggers,VIEW,Procedures
What are the steps needed to create a simple basic datastage job?
how to write server Routine coding?
How and where you used hash file?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
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 sortmerge collector?
Differentiate between validated and Compiled in the Datastage?
how can we create rank using datastage?what is the meaning of rank?
What is the different type of jobs in datastage?
what is repositery?
How to reverse the string using SQL?
State the difference between an operational datastage and a data warehouse?
What could be a data source system?
Where do the datastage jobs get stored?