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 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!
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 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!