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
- 7851 Views
- I also Faced
- E-Mail Answers
Answer Posted / sindhu
BY using sequential file in format delimeter =none while importing the data enable the option fixed width and give column width 5 space 5 space 5.datatype as varchar inorder to get zeros also in output.
reducing the stages will always increase performance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the stages in datastage?
What are the important features of datastage?
Have you used Unstructured data?
how to abort the job its matain duplicates?
how to implement scd2 in datastage 7.5 with lookup stage
What are the types of hashed files in data stage
CHANGE CAPTURE
How to manage date conversion in Datastage?
What all the types of jobs you developed?
How the ipc stage work?
Name the different sorting methods in datastage.
What is the purpose of interprocessor stage in server jobs?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are orabulk and bcp stages?
