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 |
What is the way to execute pl/sql script using informatica mapping?
wf dont have integration severances how you can run?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
In warehouses how many schemas are there?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is the use of target designer?
Which will beter perform IIf or decode?
how many data models u have done in informatica project?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is the difference Between Mapping parameter and variable
What is dimensional table?