Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aakanksha
Well its actually the concept of SCD (Slowly changing
deimension)which are of three types type1,type2,type3
Type1:-keeps the information about the current record and
no history is maintained it it.
Type2:-Keeps the proper historical information by including
a surrogate key or we can say a flag which will indicate or
point to the currwent information.
Type3:-Keeps the partial historical information we main
tain it by keeping or including two columns say start date
and end date but it si not that much helpful as compare to
the type 2 slowly changing dimension as type 2 provides
more information than type3 .
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What is cognos powerhouse?
What are the types of security?
When we save a report in report studio with what extn it save?
Can you define set to be cardinality?
what is the procedure for scheduling conditional rendering?
What are the components used in web tier?
Can you explain cognos planning?
What do you understand by the term 'dynamic cube'?
Define metrics studio?
What is the importance of having monitor service in cognos?
Can you define a query subject?
What is the use of Cognos scenario?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What are the types of hierarchies?
