tnormalize vs denormalize

tNormalize	tDenormalize
The tNormalize component can be used to normalize data that is stored in a denormalized format. It can also be used to split a single column of data into multiple columns	The tDenormalize component can be used to denormalize data that is stored in a normalized format. It can also be used to combine multiple columns of data into a single column.
It can normalize data from a variety of sources, including flat files, databases, and web services	It can denormalize data from a relational database.
It can normalize data using a variety of normalization techniques, including first normal form, second normal form, and third normal form	It can denormalize data using a variety of denormalization techniques, including storing data in a single table, storing data in a materialized view,and storing data in a star schema.
It can create a normalized schema for the data.	It can create a denormalized schema for the data.
It can generate SQL statements to create the normalized database.	It can generate SQL statements to create the denormalized database.
Use the tNormalize component if you need to organize data into a consistent and efficient format.	Use the tDenormalize component if you need to improve the performance of queries that access a small number of columns.
Input data:Flat files, databases, web services.	Input data:Relational database.
Output data: Relational database.	Output data: Flat files, databases, web services.
Normalization techniques: First normal form, second normal form, third normal form	Normalization techniques:Storing data in a single table, storing data in a materialized view, storing data in a star schema
Use cases: Improves data quality, makes it easier to query and update data	Use cases: Improves performance for queries that access multiple columns of the same entity