Generating XML files using Informatica

[rhitesh02]

Hi,

I have a business requirement where I need to create XML file. My Source is Oracle and Target is XML file.

I tried creating xml file but it is not creating node elements in XML. Any one who has worked on this type of thing PLEASE HELP.

Thanks,

Hitesh

 

[rhitesh02]

Hi,

I got solution for Creating XML file using informatica.

create 2 seperate flat file sources.

Join them using Dummy join, for e.g. PK =1.

Use joiner transformation to join Master and Detail record.

Attach output to Target XML.

Hitesh