Answer Posted / sharath.dwh
NORMALIZATION MEANS TAKING A RAW DATABASE AND BREAKING IT
INTO LOGICAL UNITS CALLED TABLES IS CALLED NORMALIZATION.
DENORMALIZATION MEANS TAKING A NORMALIZED DATABASE AND
MODIFYING IT TO ALLOW CONTROLLED REDUNDANCY
FOR INCREASING DATABASE PERFORMANCE IS CALLED
DENORMALIZATION.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
-----------Diff b/w OLAP and RDBMS?
What do you mean by drill across?
Define datastores in cognos?
Can you define transformer?
What are the types of catalogs in cognos?
Name the types of gateway?
write a query to display the departments with no employee?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is the size of database for you project?
What do you understand by ‘ibm predictive maintenance and quality’?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is a Cube?
----------------------What are the User Securities?
What is a dimension?
can we insert all types of charts in a list report? what r the realtime prompts?