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
Explain do we need an etl tool?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are three tier systems in etl?
how do u extract data from different data sources explain with an example?
what are Lookup caches options? Including persistent caches.
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is abap? What are idocs?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
explain the methodology of Data Warehousing?(Polaries)
what is the meaning of upgradation of Repository?
Explain the use lookup tables and Aggregate tables?
what are the reporting tools and difference between them?
Do we need an ETL tool? When do we go for the tools in the market?
how many maximum session supports to multiload in teradata ??