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
What errors and types of errors you faced in Cognos ReportNet?
What is Additive function?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are all the types of hierarchies?
How can we Maintain the Cube Security by Category level and Dimension level ?
What do you mean by query studio?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is drill down and slicing and dicing whats the difference between them?
What is the use of cognos decision stream?
What are products of cognos?
Write some methods to apply securities in framework manager model?
what are the features in cognos8ui
How can I test reports in cagonos?
Mention the difference between ‘macros’ and ‘prompt’?
What are shortcuts? Where it can be used? What are the advantages?
