We have a requirement to create a Flat File schema for following file
format
[All Mandatory]:
Header
Detail
Detail
Detail
-
-
-
Trailer
None of the records [Header, multiple Detail, Trailer] has any Tag
Identifier. Normal schema will fail to parse such file as it won't know
that
last record is a Trailer record.
I have set the schema Parser Optimization property to "Complexity" &
Lookahead Depth = 0 but that does not help.
I have read about the workaround for this in some blog where it was
mentioned that the Trailer record should be made optional and parse whole
file. This means that the last Detail record will actually be Trailer
record.
Then manually get rid of the Trailer record.
I feel I cannot implement this solution 'coz in my case I have to debatch
the i\p message in custom dissassembler. After debatching, I need to
validate
the Header & Trailer and further call few orchestrations to complete the
process.
Also the Trailer needs to be re-calculated [E.G recordCount per debatched
msg] for each debatched message & stored as a part of that message.
The orchestration instances will run parallel for these debatched messages
&
will need the re-calculated Trailer values.
Is there any way I can have Trailer as a part of my i\p schema [Not
Optional] & still parse it well without having a Tag-Identifier??
Any suggestion is appreciated.
-Thanks
