what is meant by slowly changing dimensions?

Answer Posted / mahesh225

The data present in the dimension table changess from time to time.

For example .

Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.

So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is it possible to export the webi reports to crystal reports?with out using businessview?

1817


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

598


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1723


what are the tables used in health care domain project and columns used in report?

4035


Explain what are the measure objects?

549






How to execute the plsql procedure from the report by clicking with mouse?

618


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


What is object stores?

583


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1815


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1972


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


In banking domain how many Fact tables,Dimension table are present?

8377


What three things do you consider to be the most important factors for a manager?

595


Explain what task is 98% of the required work of a business analyst?

600


what is document design in boxi,have u participate in that

1663