Interested to Buy Any Domain ? << Click Here >> for more details...
In the source seq file have 2 columns, i.e
input:
col1,col2
1,1
2,rajesh
3,15000
4,2
5,suresh
6,16000
7,3
8,veeru
9,17000
I want in the output like:
eno,ename,sal
1,rajesh,15000
2,suresh,16000
3,veeru,17000
any one answer this scenario
- 3 Answers
- 7850 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 2 then outputlnk.col2=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 0 then outputlnk.col3=inputlnk.col2
else inputlnk.col2
use above conditions in transformer stage
and then
change the column names using modify stage
as col1 = eno
col2 = ename
col3 = sal
let me know right answer, if i'm wrong...
..
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are the different options associated with dsjob command?
What are the different layers in the information server architecture?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
I have a few records just I want to store data in to targets cycling way how?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the difference between hashfile and sequential file?
sed,awk,head
How do you import and export data into datastage?
Define Routines and their types?
how to add a new records into source?
Describe the architecture of datastage?
How do you schedule or monitoring the job?
Name the command line functions to import and export the DS jobs?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Describe stream connector?
