-
Fact Table
Fact Table is a) Completely Normalized b) Partially Normalized c) Completely De-normalized d) Partially De-normalized
-
Informatica error while creating system DSN
Hi,Can you please tell me whether Informatica 7.1.1 powercenter version can be installed on windows XP professional. Iam trying to install both client and server on the same machine.But when Iam trying to create a system DSN from Source Analyzer menu, the application gets terminated it self.Please advise me if it should work.Thanks,
-
How to join the tables when there is no matching point and related keys?
What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)