Content Comparison

1. What are Dataflows (Gen2) ?
   
   They are a type of cloud-based ETL tool for building and executing scalable data transformation processes.
   

2. What’s the purpose of Dataflows (Gen2) ?
   
   They are used to ingest and transform data from multiple sources and then land the cleansed data in another destination.
   

3. Why are dataflows important in end-to-end analytics ?
   
   They allow data engineers to prepare and transform data, ensure consistency, stage data in preferred destinations, reuse data and more easily update data.
   

4. What are the benefits of using Dataflows (Gen2) ?

   1. Extend data with consistent data

   2. allow self-service users access to a subset of data

   3. Optimize performance

   4. Simplify data integration
      
      

5. What are some common data transformations in Dataflows (Gen2) ?

   1. Filter and sort rows

   2. Pivot and unpivot

   3. Merge and append queries

   4. Split and conditional split

   5. Replace values and remove duplicates

   6. Add, rename, reorder or delete columns

   7. Rank and percentage calculator

   8. Top N and Bottom N
      
      

6. How can Dataflows be incorporated into pipelines ?
   
   They can be incorporated into a pipeline to orchestrate extra activities like executing scripts or stored procedures after the dataflow has completed.

...