No, PowerCenter does not support files that are in Java Script Object Notation (JSON) format. Pmdtm is only capable of reading flat files (fixed or delimited), XML files, and so on. JSON is not a format that is readable by the dtm code or by the Designer for parsing the metadata.
Thank you for posting your query.
If you would like to generate the JSON output using PowerCenter Designer, then you will need to make use of the Java Transformation and write custom java code to achieve this.
If you plan on using the developer client , then you can make use of the data processor transformation.
Below are the steps for the same :
Please let us know if this helps.
Not 100% correct with regard to PowerCenter.
It is quite possible (and has been done by quite a few people who have asked on this forum) to create the JSON contents using an Expression transformation. Whether this works or not in any particular use case, that's a different question and needs to be answered for each case individually. That mainly depends on the complexity of the JSON structure.
Making a simplified statement here, if the JSON output is not hierarchical, then an EXP should work fine. If you do have to create JSON output with more than one hierarchy level, then it might be necessary to use a Java transformation. However, to give really educated advice, we would need to see a typical sample output case.
Either way, in general it's not as easy with PowerCenter to create JSON output as it may be with the Informatica platform (where you use the Developer client).
1 of 1 people found this helpful
As Nico mentioned, it would be different for case by case. When you have complex hierarchy, its not very easy to create the output with existing transformation other than JAVA transformation on it.