Interested to Buy Any Domain ? << Click Here >> for more details...
What is slowely changing dimensions?why we are used SCD?
- 2 Answers
- 7078 Views
- I also Faced
- E-Mail Answers
Answer Posted / nasa
these are three types
type-1
type-2
type-3
type-1: it will not maintain historical data... that means
if you update the record it store but it will remove
previous data
type-2: type -2 maintain historical data. it store new data
by row wise..
type-3: type-3 also maintain historical data but it stores
data column wise and it allow limited nearly 250
but type allow more that 250 so type-2 is the best...
| Is This Answer Correct ? | 0 Yes | 0 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 r the names of the reports that you prepared?
What are the considerations regarding performance kept in mind while setting up cognos?
What DB View and Bus View?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What are slice and dice?
i have one file i saved in csv how can i take these file into framework manager
how you create security to reports?
Can you define slice?
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
How to Reset Pagenumbers in one report.
what is stitch query in reportnet?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
How do you call a store procedure within a transformation?
