Answer Posted / naresh
slowly changed/growing dimentions are 3 types
scd1 : it displays only current information it does not
display any historical infomation.
scd2 : it displays current + Historical information(full
histiry)
scd3 : it displays partial historical information not full
history
ex: bank mini statements last 10 trasactions
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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?
what is the difference between list report and crosstab report?
What do you understand by the term 'dynamic cube'?
What is model filter?
What is a dimension?
Define dimensions?
What are the main services provided by application tier?
What is metric store database?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
write a query to display the departments with no employee?
-----------With out using DrillThrough how to do Reports?
Can you define drill down and drill up?
What are slice and dice?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Can you define bitmap index?