Software Engineer ETL Developer Interview Questions and Answers

Active transformation changes the number of rows in the data flow, while passive transformation does not.

• Active transformation changes the data flow by adding, deleting, or modifying rows.

• Passive transformation does not change the data flow, but may change the data within the flow.

• Examples of active transformations include Filter, Router, and Update Strategy.

• Examples of passive transformations include Expression, Aggregator, and Joiner.

Lookup and Joiner are two types of transformations used in ETL process.

• Lookup transformation is used to look up data from a source based on a key and return the corresponding data.

• Joiner transformation is used to join data from two or more sources based on a common key.

• Lookup transformation can be used for both connected and unconnected lookup.

• Joiner transformation can be used for inner, outer, left outer, and right outer joins.

• Lookup transformation can improve performance by...read more