Explain the differences between normalizer and normalizer transformation?
- 1 Answers
- 1158 Views
- I also Faced
- E-Mail Answers
Answer / Apurav Garg
Normalizer is a data integration pattern that decomposes a single large table into multiple smaller tables to eliminate redundancy. Normalizer Transformation in a tool like Talend refers to the process of applying this pattern during ETL operations. On the other hand, a Normalizer is also a component in some tools that normalizes the data according to a specified normal form (like First Normal Form or Boyce-Codd Normal Form).
| Is This Answer Correct ? | 0 Yes | 0 No |
What Oracle features can be used to optimize my Warehouse system?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What's a Cube in Rolap?
What is MDX?
How to calculate fact table granularity?
Explain what is a cube in data warehousing concept?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
How to create different types of templates?
Who needs data warehousing?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain a relation schema and a relation?
Teradata 
