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
Explain what are the steps to do to use alerts in bo?
What are the steps to do to use alerts in bo?
Explain the difference between union and group?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Which versions are used in the bo dashboard work?
How were the reports scheduled and how to resolve unexecuted documents?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Give some information on report bursting?
how to create reports on screech?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to generate the report from excel sheet?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is the profile and package?
How would you format some text using css to be verdana and bold?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye