Challenge in creating multiple PDF files in Informatica

0
votes

I am facing some challenge to create multiple PDF files in informatica 10.2.0, Please find the details below:

Requirement : - We need to spilt single xml file into multiple PDF files based on condition.

Tools used : - Informatica Powercenter, Informatica Developer.

Challenge : - I have created data processor in informatica developer and used this as service in informatica powercenter and created single PDF file But not able to create multiple PDF files with this service. I have used sorter to sort the file based on my condition to split the file and then used transaction control to commit records based on the condition used and passing these records to the UDT transformation (calling service in this transformation) and then passing the output Buffer port to target. Here in UDT transformation I have given Input type and Output type as 'file' in UDT settings tab in mapping.

Could anyone please provide suggestion to achieve a solution for this technical challenge.

2
informaticainformatica-powercenter
Transaction control is for timing your commits, why aren't you using a router to split the pipeline and direct the records to separate targets? – Daniel Machet
Alternative is to sort by your file split criteria earlier in the pipeline then the transaction control file splitting would make some sense – Daniel Machet
We are doing the same way which you mentioned, i.e, we are sorting file based on the split criteria and then using transaction control to split the file. It is creating multiple PDF files but data is not getting split, instead all records are loading to all the PDF files which is created. – Divya
@DanielMachet Please be informed that I have updated my question so that I guess now you will be able to understand my issue in detail. Please let me know if you require further details. Also for your information it is not necessary for me to use XML file only as source I can go for text file as well, I have tried with text file as source also. Thanks for responding. – Divya
I'm scratching my head I'm afraid, one unknown for me is udt which I've not used before - have you tried routing the records to a flat file as a test to see if the same behaviour occurs? Also (and I'm clutching at straws here) are you using a filename port for the output files? – Daniel Machet

2 Answers

0
votes

create a variable to identify when a change or new xml is processed and use this to issue commit/continue in the Transaction control.

0
votes

I think the transaction control is probably the wrong route to use here - try this https://kb.informatica.com/howto/6/Pages/1/154788.aspx