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
- 7908 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 devoleper roles in real time? plz tell i am new to datastage....
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are data elements?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How to find value from a column in a dataset?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
On which Dimension Table you implemented SCD Type in your Project
How one source columns or rows to be loaded in to two different tables?
What are the different options associated with dsjob command?
How many types of stage?
Which warehouse using in your datawarehouse
Define oconv () and iconv () functions in datastage?
how many rows sorted in sort stage by default in server jobs
If you want to use a same piece of code in different jobs, how will you achieve this?
what is repositery?
