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
- 5557 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the components of datastage?
what is executable in DataStage?
Is possible to create skid in dim,fact tables?
Define data aggregation?
what is diff b/w datastage 8.1,8.5,8.7?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
how to retrive the max(sal),deptno,empno in datastage?
What is the difference between account and directory options ?
What are the different plug-ins stages used in your projects?
What is the use of datastage designer?
Where do the datastage jobs get stored?
Teradata 
