Originally Posted by
PARAMASHIVAN
Ramdas
That's great stuff, I am actually working as SQL server / BI Developer, Primarily on SSIS , SSRS on 2008.
Have you got experience in Datawarehouse development, If so can you pls briefly explain the procedure of creating a datawarehouse? Like for Relational Database , you would normalise the data, come up with enitities, then draw up an entity relation ship diagram, then from that you would create the tables, Pk, FK, views, ...etc
I know in Datawarehouse, it is de-normalised data, and you have fact tables/dimensional tables..etc. Can you briefly explain them to me pls
thanks