Originally posted by: teapott

hello

I am new to wts and have struggled so far with the forums and documentation to fully understand the design options open to me.

I'd be grateful for any pointers to get me going.

Scenario
Input File: large xml batch file with 1X header detail and a repeating 'record' block
Output:
1. File to single message/file consisting of multiple, header + record details
2. File to message/file consisting of n header + record details

I hav elooked at the post recommending 'burst' and see how that works for grouping output, but not how to attach the a copy of the header to each record.

Thanks
B
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Unless your input is very big (200MB+) I wouldn't use burst mode.

To get the right numbers of headers output you need to define your output trees and then create functional maps to pass the input header down with each detail record.

it should become clearer once you've created the trees and started doing the mapping.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: teapott

Thanks Oliver

Making more sense the longer I play with the product. The files will be considerable (GB), so I am assuming 'burst' mode maybe appropriate.

If anyone has any gotchas to watchout for that would be helpful.

Thanks in advnace
B
..
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

if you're handling several GB, then then yes - burst mode would be a good idea.

The problem you will then have is that burst mode expects to process a complete message (i.e. a file would look like msg1:msg2:msg3) - in XML you would have a opening tag at the beginning of the file and a closing tag at the end - you may need to play with the input tree to make the tags optional and make burst mode work.

Generally XML is great for small single message files - I wouldn't use it for batch driven multiple GB files.
Can the app produce smaller XML files or if it's restricted to old batch driven technology, can it use a batch driven format (e.g. CSV or fixed length files)?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SailajaChaganti

Hi,

I have a similar problem.

My requirement is that I have to segment a part of the incoming file and pass it to the output without any transformation.

To be accurate, input file structure is

File
FileName
FileType
SubmissionTs
InsuredDetails
InsuredPersonalDtls
CvgDetails
EmploymentDtls

The InsuredDetails block is a repeating one and may come in 2 different formats - fixed length or delimited.
Whatever format it may be, I need to pass the Insured Details block as such to the output to store the raw data in DB.

I have tried creating a group (RecordData) in the output TT with only one element, for name sake, and tried passing the Insured Details group from input to RecordData in output.

But it throws me type mismatch error when compiling the map.

Could anyone please help me out in this?

Thanks,
Sailaja Chaganti
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SailajaChaganti

Hi,

I have a similar problem.

My requirement is that I have to segment a part of the incoming file and pass it to the output without any transformation.

To be accurate, input file structure is

File
FileName
FileType
SubmissionTs
InsuredDetails
InsuredPersonalDtls
CvgDetails
EmploymentDtls

The InsuredDetails block is of repeating type and may come in 2 different formats - fixed length or delimited.
Whatever format it may be, I need to pass the Insured Details block as such to the output to store the raw data in DB.

I have tried creating a group (RecordData) in the output TT with only one element, for name sake, and tried passing the Insured Details group from input to RecordData in output.

But it throws me type mismatch error when compiling the map.

Could anyone please help me out in this?

Thanks and Regards,
Sailaja Chaganti
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Malcolm.Cetera

Could you give more details? I have the similar question, Why it does not work here?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange