Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the meant by Normalization and de-normalization?

Answer Posted / gireesh

Normalization is a process in database design which groups
data into various tables which are then crosslinked by a
particular field. In a properly normalized database, there
will be only one field in one table for a particular piece
of data, eliminating possibility for conflicts. Breaking the
database up into numerous smaller tables, and eliminating
redundancies, eases management and enhances efficiency.

Is This Answer Correct ?    24 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of transformations supported by sorted input?

1199


What is the difference between round-robin partitioning and hash partitioning?

957


what is the difference between cardinality and Nullability?

3425


Identifying the bottlenecks in various components of Informatica and resolving them.

1916


Mention few test cases and explain them?

918


if i have a query as flat file how can we load data to target table

1379


Can there be sub steps of etl steps?

1003


Explain and compare etl & manual development?

911


Define Dynamic push down optmization?

2284


what are the cubes developed in a sap bw project and what is the requirement for developing it?

2055


Explain what are the various etl tools in the market?

916


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1177


What do you understand by active and passive transformations?

925


What are dimensions?

1042


What is grain of fact?

947