Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization? explain 1st NF, 2nd NF, 3rd NF
- 1 Answers
- 11459 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 limitations of joiner transformation?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
what is scd?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
explain about session partitions ?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Explain what transformation and how many are there in informatica?
What is confirmed dimension?
Explain lookup transformation in informatica
What happens if the info. Server doesn't find the session parameter in the parameter file?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Teradata 
