Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11456 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
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
how we can load rejected record's at run time?(not through bad files)
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to update a particular record in target with out running whole workflow?
What is mapping debugger?
Explain the shared cache and re-cache?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to improve the performance of a session using sorter transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain what are the different types of transformation available in informatica.
Mention few power centre client applications with their basic purpose?
What are the different types of repositories created using informatica?
What are the popular informatica products?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
