When would you denormalize?

Answer Posted / sandipan sinha

if I am in need to see the data set in a tabular format
where for each column entry in primary key we can have more
than one entries in other columns,ssometimes they are
needed to be added and summed up together.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the example of procedure?

678


What is mdb stand for?

733


How would you convert date into julian date format?

793


what is log shipping? : Sql dba

825


Whis is not false in primary key?

1170






what is normalization? : Sql dba

737


how tsql statements can be written and submitted to the database engine? : Transact sql

716


what is sql server agent? : Sql dba

772


What is column?

725


What is union, minus and interact commands?

939


What is data type in sql?

729


How many types of relationship are there?

738


What is the maximum number of columns in sql table?

781


a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1956


Define implicit and explicit cursors.

811