Does that mean you have to create a mainframe file? If so, what's the record format? Wouldn't it be better (if my assumption is correct) to use PowerExchange for mainframes (PWX) to create this file? Now I'm no mainframe guy, but as far as I understand this matter, creating such a file using PWX should be a breeze.
Yes, I am planning to use powerexchange to generate the files. as per my understanding, I need to create target definition using powerexchange, then populate this using powercenter mapping. it will generate EBCDIC file. when creating TARGET definition, one copy book, create 3 definitions: header, trailer and detail. my question is how could I generate one EBCDIC file which includes header, detail and trailer.
Unfortunately, this is one of those areas where PWX isn't as smart as we would like.
PWX can handle writing a multiple-record file - but only if sourcing from a multiple-record file.
Today, there is no way inside PWX to source from 3 different Oracle tables and write to the same output file.
You could create 3 output files, but then you would have to concatenate them somehow in a post-session command. Doing that on LUW would be problematic, as the way LUW and z/OS handle end of line and end of file is very different.
You might need to use PWX on z/OS to write the 3 files, and then run something there to merge the 3 files in the correct sequence.
If you are willing to add another port in the PC mapping (for each table), then it should be possible.
Add a sequence field to each table.
Force the header sequence to 0
Generate a unique sequence for each detail record.
Make the trailer sequence the max value.
For the target, create a multiple-record datamap.
If you want to attempt this, please raise a case with support.
Another option is to have 3 mapping sessions and chain them together in a workflow.
Mapping1/session1 writes the header record
mapping2/sesssion2 appends the detail data
mapping3/sesssion3 appends the trailer record
The file will be closed after each session complete, which allows it to be opened appropriately in the subsequent session.
That sounds like a much cleaner approach.
this is first time working for EBCDIC target, could you please provide more detail how to append the data into EBCDIC file.
thanks in advance.
I would suggest raising a case with PWX Support for more details.
I haven't worked on raising case with PWX support. could you please share the steps how to raise the case with PWX support
Thanks in advance
Customer guide to GCS can be downloaded from:
If you are listed as a read/write contact on a GCS Support Project, then you should have an "Access eSupport" link or button on your home page when you login to network.informatica.com.
Alternately, you could call the Informatica Global Support line, and ask them to raise a case.