Okies...yes, i have been through it and it would be a TYPE 2 SCD, that is why the History Table Thanks
Guys - i want to implement something like Slowly changing dimension for the above.
We have a Policy Fact table, where we need to track the changes made to the Policy. (i.e When it is Lapsed or reinstated based on Status, when it is...
Hi Friends, I have a Fact Table(Daily Truncated and re-loaded) for which i need to create a History Table. As a First Step the Empty History Table...
Thanks - However, the total Bytes for all the columns comes to more than 60 Bytes..and the Trandate column contains only the date portion, and not...
Hi Friends, We have a Transaction Fact Table which contains 21 Columns and 4998000 Records (Almost 5 Million). The Uniqueness of a Record can be...
No - We are just using SQL Server 2000 to store Data, and are using Cognos for our reporting requirements. So wanted to know, for complex ad-hoc...
Hello Friends, We have created a Datawarehouse System, on SQL Server 2000. Our DW Design is very much based on Snowflake Design (Bill Inmon). Apart...
Yes - That is what now we plan to do, while extracting the data, to be loaded we plan to manipulate the data there itself. Thanks Deeps
Madhavan - Yes, i know that but then i dont have control over the system from where we extract the Table, and we use this Table to load into our...
Hello Gurus,<br /><br />I have a table where i have a few columns and one Column(UPDATE_DATE) where the date is stored in String Format eg...
Thanks..for all the help !!!..well noted the points....
Thanks for the Reply.. Also, do i need to make use of Fill Factor as 100%, as i am dropping and rebuilding the indexes and the Table will not be...
Hello Friends, I have a Table which gets loaded daily and it is a Truncate and Full Load (i.e Daily the Table gets Truncated and a Full Load using...
Separate names with a comma.
