Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39237 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / dhirendra kumar
DENORMALIZATION IS A TECHNIQUE TO MOVE FROM HIGHER TO LOWER NORMAL FORM IN ORDER TO SPEED UP THE DATABASE ACCESS.WHEN WE WANT TO DERIVE PHYSICAL DATA MODEL FROM LOGICAL DATA WE USE DENORMALIZATION.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Who are end users in dbms?
Write short notes on manual refreshes.
Explain about network model?
Explain what a database is?
How can you log an error to the server event log from a stored procedure?
What are data modelling techniques?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
explain detail about ftp in datastage?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How you can make a parameterized view?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about relational database management systems?
