Data Integration

 View Only
  • 1.  Data Integration current and archived into FM Model to build reports with combined data

    Posted Wed June 07, 2023 11:34 AM

    We are using cognos for operational reporting out of Manhattan TMS and EEM applications. Over a period data size increased a lot and report performance is very slow. We want to archive the historical data into separate schema in DB, so that reports perform to its best. However business still wants to have reports reading from archived DB. 

    What is the best approach other organizations are using? Can we put to set of reports one reading from current DB and other from archived DB?

    OR is it possible to modify Framework manager model to ingrate two different schemas to pull up the report?

    Appreciate any help in this regards 

     



    ------------------------------
    Mona Dhawan
    ------------------------------


  • 2.  RE: Data Integration current and archived into FM Model to build reports with combined data

    Posted 22 days ago

    Hi

    If you are using Db2, you can use Range Partition and TableSpace to manage the data - https://www.ibm.com/docs/en/db2/11.5?topic=groups-data-management-using-multi-temperature-storage



    ------------------------------
    HOW MING YONG
    Senior MLOps and Governace Technical Specialist
    IBM
    Melbourne VIC
    ------------------------------