Hi Mike,
I am sorry about that, I just did not want to bombard everything which may not be relevant. Below is all the information of the job:
Code: Select all
SQL Server Table
||
||
Sequential File ==> Transformer ==> Join ==> Lookup ==> Transformer ==> Sequential File
My source is a multi header/detail sequential file , I am reading everything as a Varchar(255) followed by splitting the detail records in the transformer, join them based on a key column and lookup on a sql server table , perform the following two transformations and send output to the sequential file. All the columns across all stages are Char. As per business requirement ,the output file must match the sort order of the file created by the existing legacy process (informatica), so I have explicitly made every stage to run sequentially. (Please forgive my ignorance if this is a very inefficient way to use Datastage, I was able to get the same sort order only by this way)
Right(MyLinkName.GFA_Column11,15)
Right(MyLinkName.GFA_Column12,15)
Here are my target columns with their datatypes:
GFA_Column1 - Char(7) - Nullable = NO
GFA_Column2 - Char(8) - Nullable = NO
GFA_Column3 - Char(20) - Nullable = NO
GFA_Column4 - Char(1) - Nullable = NO
GFA_Column5 - Char(7) - Nullable = NO
GFA_Column6 - Char(8) - Nullable = NO
GFA_Column7 - Char(3) - Nullable = NO
GFA_Column8 - Char(3) - Nullable = NO
GFA_Column9 - Char(1) - Nullable = NO
GFA_Column10 - Char(9) - Nullable = NO
GFA_Column11 - Char(15) - Nullable = NO
GFA_Column12 - Char(15) - Nullable = NO
GFA_Column13 - Char(1) - Nullable = NO
GFA_Column14 - Char(3) - Nullable = NO
GFA_Column15 - Char(8) - Nullable = NO
GFA_Column16 - Char(2) - Nullable = NO
Required output :
Code: Select all
00019152012021603000000378 F004012620120216025153S00014690000000000011453200000000077966017672012021600
Current Output: APT_STRING_PADCHAR = 0x20
Code: Select all
00019152012021603000000378 F 0040126 20120216025153S00014690000000000011453200000000077966017672012021600
I am treating all the fields as Varchar/char even though some of them are dates, some of them are amounts, counts etc.
I really appreciate your time and help in this.. sorry If I have not been clear/informative.
Thank you