Loading Staging tables using PL-SQL/ETL tool

[snadgir30]

Hi All,

This being 1st attempt on metrics project , we have decided to avoid use of Metric Designer (MD) for loading staging tables.

  1.Now can any one tell me how one should go for staging table loading using PL-SQL or ETL tool?

  2.Do we need to populate all the tables staging tables mentioned or selected ones only?

  3.Any do's and dont's that should be followed.

  4.does any one has doc / cognos has provided that list detailed steps to be followed while ETL loading of staging tables.


help appreciated!

[francois]

No answer for you.
Just a question : why not using MModeling ?

[JoeBoxer]

Hi All,

This being 1st attempt on metrics project , we have decided to avoid use of Metric Designer (MD) for loading staging tables.

  1.Now can any one tell me how one should go for staging table loading using PL-SQL or ETL tool?

Very carefully, and with surgical precision.

  2.Do we need to populate all the tables staging tables mentioned or selected ones only?

Selected tables only.

  3.Any do's and dont's that should be followed.

Do read the appendix.  Do make backup.
Don't work on production data.  Don't ignore the staging table appendix in the users guide for author.

  4.does any one has doc / cognos has provided that list detailed steps to be followed while ETL loading of staging tables.

Understanding the full structure of the staging table appendix, as well as the tab-delimited file appendix will give you a significant start on how the staging table should be populated.  If you find that you learn better hands on, what you can do is setup a sample metric store schema, and export your metric store to file, and then load those to your staging table to see what entries gets populated.  You can narrow out the complexity by paring down to only the data content you are looking to load.  For example, metric actual, and target data only.  Once you get the hang of that, it will take you no time to translate that new found knowledge to being able to populate that staging table directly via pl-sql, or etl tool such as data manager, or informatica.

help appreciated!