Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11639 Views
- SunGard, I also Faced
- E-Mail Answers
Answer / 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 |
What are the components of the workflow manager?
What are the types of maping in Getting Started Wizard?
what is mapping parameter and mapping variables
How can you differentiate between powercenter and power map?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What is an MDDB? What is the difference between MDDBs and RDBMSs?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
how to we create datamart?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Teradata 
