tfileouputpositional having issues while loading

[Sudhee_Maximus]

Hi There,

I am trying one to one load by munging data (String) and loading back to positional file ...

fileinputpositional-->tmap-->fileoutputpositional  both structures are same , but while loading data to target I get attached error.

any help in  resolving this issue is really appreciated... 

[manodwhb]

@SudheeReddy ,can you share the error and configuration of tfileouputpositional ?

[Sudhee_Maximus]

@manodwhb 

 Thanks for your reply please find the screenshot below and export of metadata attached
 

outbound.xml
outbound.xml

[manodwhb]

@SudheeReddy ,since you have not configured  tfileouputpositional because of which you are getting compilation error. can you share the  component settings of  tfileouputpositional?

[manodwhb · Accepted solution]

@SudheeReddy , it is configuration issue in tfileouputpositional ,because of the you are getting compilation error ,could please check configuration of tfileouputpositional and can you share the screenshot of tfileouputpositional?

[Sudhee_Maximus]

Hi @manodwhb ,

I don't feel its a configuration issue as I am able to read file with the same configuration of file and trying to generate same output file without any changes ...

the only thing I am doing in between is munging (that too is a string with same size)...

could you please let me know what changes or config you are talking about ?

[Sudhee_Maximus]

figured out the issue, even though I gave size for each columns some of them are not updated and were having no values(size) .... I guess even-though its a string, we need to provide the no of chars(size) it can accept for fixed file delimited files so that it can process the data.

got my answer @manodwhb ... now I don't see the error any more . Thanks !

[manodwhb]

@SudheeReddy ,why you have not specified size for few coulmns?

[manodwhb]

@SudheeReddy , you need to provide size for each and every column in tfileouputpositional.

[Sudhee_Maximus]

not sure @manodwhb 

I have provided the size (as you know we need to specify column size for each col in fixed width), but when it scans the file and find no data in the column it updates with no size / may be some issue .

it has created the column but not the size of it (not assumed this to happen when each column has been defied with specific size while creating  ).