what is the meant by Normalization and de-normalization?
- 2 Answers
- 8119 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are the session parameters? How do u set them?
SCD2 will work on only dimension tables as well as fact Table?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the steps involved in etl process?
What are the differences between sql override and update override?
Give the benefits of data integration suite?
how do u handle performance issues in Informatica . where can u monitor the performance ?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain about etl data integration software?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
list and discuss two approaches for updation of target table in Informatica and how they are different.
Two default user groups created in the repository are____and_____.
what is pmrep command?
