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
what is the use of server?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Explain do we need an etl tool?
what are the session parameters? How do u set them?
Define slowly changing dimensions (SCD)?
Explain do we need an etl tool? When do we go for the tools in the market?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What is etl process. How many steps etl contains explain with example?
What is a materialized view log?
Explain and compare etl & manual development?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is a worklet?
What is meant by incremental load?
Explain about enterprise scalability and roi of data integration suite?
State the differences between shortcut and reusable transformation