Interested to Buy Any Domain ? << Click Here >> for more details...
in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....
- 4 Answers
- 7912 Views
- I also Faced
- E-Mail Answers
Answer Posted / anat
Hi as per my knowledge pls follow the below steps
1)take entire source as single colom
2)in transfomer split that colom in to multiple coloms by
using substring or field functons
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the method of removing duplicates, without the remove duplicate stage?
how can we create rank using datastage?what is the meaning of rank?
What is a ds designer?
Name the command line functions to import and export the DS jobs?
What is quality stage?
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?
What steps should be taken to improve Datastage jobs?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Where do the datastage jobs get stored?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How do u convert the columns to rows in datastage?
Define Merge?
Highlight the main features of datastage?
Differentiate between Join, Merge and Lookup stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
