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
How to join multiple db in catalog?
tell me two or three issues from client side and how to solve those issues?
Can you define materialized view?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Define query studio?
What is the size of the cube?
What do you understand by the cognos?
What is meant by drill down?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How can we create a dynamic column name in cognos?
What are all types of Batches?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is difference between primary key and unique key constraints?
----------------------What are the User Securities?
