what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
4 21871Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
1 7757what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
IBM,
1806what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 7189i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
1579I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
1 4912Post New Data Warehouse General Questions
Explain what are the modules in power mart?
List down some of the real time data-warehousing tools?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain when do we analyze the tables? How do we do it?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Can we take backup when the database is opened?
How do you create surrogate key using ab initio?
What are aggregate tables and aggregate fact tables?
Explain what are the various file formats involved in reportnet?
What is type 2 version dimension?
What is informatica architecture?
What is VLDB?
What is incremintal loading?
Explain where do we use semi and non additive facts?
Explain why are oltp database designs not generally a good idea for a data warehouse?