Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11483 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 |
difference between shortcut and reusable transformation?
what is session override?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
what is data driven?
What is informatica metadata and where is it stored?
What is data movement mode in Informatica and difference between them?
To achieve the session partition what r the necessary tasks u have to do?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are the different threads in DTM process?
Is it possible to define a single node as a Gateway node as well as worker node?
scenario
Whats the difference between informatica powercenter server, repositoryserver and repository?
Teradata 
