Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11554 Views
- SunGard, I also Faced
- E-Mail Answers
Answer Posted / rakesh
Data normalization is a process in which data attributes
within a data model are organized to increase the cohesion
of entity types. In other words, the goal of data
normalization is to reduce and even eliminate data
redundancy, an important consideration for application
developers because it is incredibly difficult to stores
objects in a relational database that maintains the same
information in several places.
Level
Rule
First normal form (1NF)
An entity type is in 1NF when it contains no repeating
groups of data.
Second normal form (2NF)
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary
key.
Third normal form (3NF)
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.
| Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to do the error handling of if ur source is flatfiles?
How would you join a node to the already existing domain?
Differentiate between joiner and lookup transformation?
On which transformations you created partitions in your project?
Explain the features of connected and unconnected lookup.
What is dynamic cache?
What is session task and command task?
How can we store previous session logs?
What does refresh system mean, and what are its distinctive choice?
Differences between version 7.x and 8.x.
How to generate sequence numbers?
define galaxy repository in informatica
How can you define user defied event?
Different circumstance which drives informatica server to expel records?
