Explain what are the various transformation available?
- 1 Answers
- 1113 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
