1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is normalization? explain 1st NF, 2nd NF, 3rd NF

Question Posted / ahalya inturi


what is normalization? explain 1st NF, 2nd NF, 3rd NF..

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

Post New Answer

More Informatica Interview Questions

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

what we require for D.modelling?

1 Answers  

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  




What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

Diff b/w ShortCut and reusabel Object ?

4 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

what is lookup ?

7 Answers  

what is lookup chache?

1 Answers   Patni,

For more Informatica Interview Questions Click Here
Categories