Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11633 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
Define mapping and session?
How can we use mapping variables in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
What is rank transform?
Difference between Data and Index Caches?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is native users?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what are 3 tech challenges/ common issues you face?
What are connected or unconnected transformations?
What is the meaning of decode in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Where can we find the throughput option in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the difference between STOP and ABORT options in Workflow Monitor?
