Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11525 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 is index?how it can work in informatica
How to use procedural logic inside infromatica?
What is the cumulative sum and moving sum?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is target load order?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can one identify whether mapping is correct or not without connecting session?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is an Integration service in Informatica?
What are some examples of informatica etl programs?
What is main use of mapplet?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is SDLC way of code development?
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?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
