sql server dts: Hi All,

Can any one give me an idea in how to plan the popluation of Fact Table
in a ware house ?.

Yep

Personally I would read

"The Data Warehouse ETL Toolkit" by Mr Kimball et al

A Fact table is nothing more than a group of facts with foreign key
references to Dimension tables that act as Discriminators for the data.

A fact without context is meaningless
A fact with context (discriminators) is information.
Information in the hands of the right people is knowledge.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


[quoted text, click to view]