Interested to Buy Any Domain ? << Click Here >> for more details...
is it sufficient to normalize a database up to 3NF?
- 4 Answers
- 7128 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
It all depends on users aproach towards data
selec/inserts/updates
... Normelization affects data retrival severely.
we can go up to BCNF
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shwetal
If possible It should be normalize upto BCNF but it completely depends on the data
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jdfiji
dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain a checkpoint and when does it occur?
What is the use of COMPRESS option in EXP command ?
How do you invoke datastage using unix?
How do you set up a database?
What is the difference between a LIST BOX and a COMBO BOX ?
Can an Alert message be changed at runtime ?
What restrictions can you apply when you are creating views?
What the TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return ?
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.
What is the use of PARFILE option in EXP command ?
What is 1nf in database?
What is the best database management system?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
