Explain what are the various transformation available?
- 1 Answers
- 1117 Views
- I also Faced
- E-Mail Answers
Answer / Ajay Singh Chouhan
The various data transformations in a data warehouse include: ETL (Extract, Transform, Load) processes, where data is extracted from source systems, transformed to fit the target schema, and loaded into the data warehouse. Some common types of transformations are Data Cleaning (removing or correcting invalid or inaccurate data), Data Integration (combining data from multiple sources), Data Aggregation (grouping data for summary analysis), Data Normalization (transforming data to reduce redundancy and improve data integrity), and Data Denormalization (reverse transformation of normalization for improved query performance).
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is the difference between datawarehouse and bi?
DWH architecture?
What are the steps of implementing data warehousing?
What is surrogate key? Explain with examples.
What is Operational Data Store?
Difference between DSS & OLTP?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are the different types of data warehouses?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Can we take backup when the database is opened?
Teradata 
