Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8600 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 |
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
how does the server recongnise the source and target databases.Elaborate on this
Explain the difference between etl tool and olap tools?
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the key benefits of ETL Testing?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Teradata 
