1 Reply Latest reply on Dec 29, 2015 7:07 PM by Tapabrata Sarkar

    Performance tuning  on XML target Worlfows

    Ramakrishna N Active Member

      The Informatica mapping was created  to load XML(more than one XML file) targets and rhe source will process with  data is 25 million rows from more than 6 tables.

      It's running since 5 to 8 hrs to generates the  XML files after completion of "Combining XML groups into final DOM tree"

       

      2014-09-23 10:25:25 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC.xml] for XML output

      2014-09-23 10:25:25 ........abcserver : XMLW_31037 : XMLW_31037 Received all the data for all the XML groups of target [TT_FULL_ARC]. Combining XML groups into final DOM tree... : (Tue Sep 23 10:25:25 2014)

      2014-09-23 10:25:25 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0001.xml] for XML output

      2014-09-23 10:52:24 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0002.xml] for XML output

      2014-09-23 11:29:53 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0003.xml] for XML output

      2014-09-23 11:58:07 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0004.xml] for XML output

      2014-09-23 12:24:30 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0005.xml] for XML output

      2014-09-23 12:50:38 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0006.xml] for XML output

      2014-09-23 13:16:25 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0007.xml] for XML output

      2014-09-23 13:41:12 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0008.xml] for XML output

      2014-09-23 14:06:46 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0009.xml] for XML output

      2014-09-23 14:31:57 ........abcserver : XMLW_31025 : Opened file [/abcde/dd/XML/TT/TT_FULL_ARC_0010.xml] for XML output

      .

      .

      How can I tune it to complete in less time?

      And any performance steps for XML targets