Different types of nodes, they are:

Join: This node is used to join two source OBJECTS and pass the result to the next node. The join types can be inner, left outer, right outer and text join.Note: We can only add two source objects to a join node.

Union: This is used to PERFORM union all operation between MULTIPLE sources. The source can be n number of objects.

Projection: This is used to select columns, filter the data and create additional columns before we use it in next nodes like a union, aggregation and rank.

Aggregation: This is used to perform aggregation on specific columns based on the selected ATTRIBUTES.

Rank: This is the exact replacement for RANK function in SQL. We can define the PARTITION and order by clause based on the requirement.

Different types of nodes, they are:

Join: This node is used to join two source objects and pass the result to the next node. The join types can be inner, left outer, right outer and text join.Note: We can only add two source objects to a join node.

Union: This is used to perform union all operation between multiple sources. The source can be n number of objects.

Projection: This is used to select columns, filter the data and create additional columns before we use it in next nodes like a union, aggregation and rank.

Aggregation: This is used to perform aggregation on specific columns based on the selected attributes.

Rank: This is the exact replacement for RANK function in SQL. We can define the partition and order by clause based on the requirement.