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
How to a create header dynamically in a crosstab report in cognos 8.1?
Is it possible to join multiple Databases in a Catalog?
Please explain the different stages in creating a report in cognos report net?
Can you define bitmap index?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
how u will determine the performence tune will occur either in report or system
What is Bitmap Index?
what is the role of cognos comsultant?what actually it means?pls reply
7. What is performance tuning?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
what is log in cognos?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
