Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8743 Views
- I also Faced
- E-Mail Answers
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 |
what is meant by drill through?(Mascot)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
Explain different types of partitioning?
Explain what are the various etl tools in the market?
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.
what are Lookup caches options? Including persistent caches.
what is dynamic insert?
SCD2 will work on only dimension tables as well as fact Table?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is tracing level? How many types of transformations supported by sorted input?
how do u decide whether u need to do aggregations at database level or at Informatica level?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Teradata 
