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....
Answer Posted / mrvprasad
Take 4 field names(field1 field2 field3 field4) in output stage.
use Transformer stage: In Derivation use the below substring
Field1: SourceColumn[1,5]
Field2: SourceColumn[6,10]
Field3: SourceColumn[11,15]
Field4: SourceColumn[16,20] use this one u will get correct o/p.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some different alternative commands associated with "dsjob"?
How a routine is called in datastage job?
How do you import and export the datastage jobs?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
table actions available in oracle connector?
What is a datastage job?
how to abort the job its matain duplicates?
What are iconv and oconv?
What is the use of datastage director?
What is the use of datastage designer?
What is quality stage?
Why do we use link partitioner and link collector in datastage?
How to reverse the string using SQL?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Which warehouse using in your datawarehouse