fixed width data in sequential file

[tejindergill]

in my file format of data is somewhat like this

aaaa111111111aaaaaayyyy-mm-dd

my target table is

varchar(4)
integer
varchar(6)
date
integer(days since the date in source till some other date)

please tell me how can i it with sequential file stage.
i can do it with transformer. but i want to optimize this job thanks in advance

[ArndW]

Since the source has no delimiters, you will need to specify columns of fixed width. While the conversions from fixed to variable length are implicit, the one from "yyyy-mm-dd" to an integer is not, so your most efficient solution will be to use a transform stage between your source and target to perform the type conversions as well as the date computation.