what is the meant by Normalization and de-normalization?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinivas
Normalization:
Normalization is a technique to reduce redundant, and
inconscistent data. normally normalization techniques use
in snoflake schema.
De-normalization:
it is a technique to move high to low normal forms in
datamodeling to increase the performance of databases.
Is This Answer Correct ? | 3 Yes | 0 No |
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
what is the difference steps for data modeling?
what is the difference between date cache and lindex cache?
Can u access a repository created in previous version of Informatica?
how would u estimate the size of Lookup transform data and index cache?
What are snapshots?
Mention few test cases and explain them?
how would u estimate the size of Aggregator transform data and index cache?
How can we use external procedural logic in informatica?
Define slowly changing dimensions (SCD)?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?