⟩ Explain What is the difference between Native SQL and Cognos SQL?
In cognos reportnet
Native SQL is used for the single datasource to import the meta data
Cognos SQL used for multiple datasources to import the metadata
In cognos reportnet
Native SQL is used for the single datasource to import the meta data
Cognos SQL used for multiple datasources to import the metadata
Explain what is OLAP?
Tell me what are Non-additive facts?
Tell me what does Metadata Respiratory contain?
Tell me what are the types of SCD?
Tell me what are the key features of chameleon that separates it from other algorithms?
Tell me what are the approaches used by Optimizer during execution plan?
What is semi Additive Measures?
Tell me what is data mart?
Explain what are the steps to build the datawarehouse?
Please explain what is Datamart?