6 Replies Latest reply on Aug 14, 2013 6:13 AM by Renato Bonomini

    Creating a generic ETL

      Share:|

      Hi Guys,

       

      I am new to BMC Capacity Optimization and any help would be greatly appreciated.

       

      I am trying to develop a generic CSV columnar ETL module by selecting multiple datasets (Example SYSDAT and OBJREL). When selecting multiple datasets with OBJREL in combination with the other datasets it is asking for extra information in the CSV Parser tab please see below

      1. Column index of 'Relation start timestamp'
      2. Column index of 'Relation end timestamp'
      3. Column index of 'Change timestamp'

       

      Could someone provide a sample CSV file to be used when selecting multiple datasets in addition to the OBJREL dataset.

       

      BCO version is at 9.0.03

       

      Thanks in Advance.