What is tracing level? How many types of transformations supported by sorted input? - ETL

What is tracing level?

- The amount of data stored in the log files is called tracing level

- The tracing levels are NORMAL., VERBOSE

- NORMAL explains the tracing levels in a detailed manner

- VERBOSE explains the tracing levels at each and every row

How many types of transformations supported by sorted input?

- Aggregator, Joiner and Lookup Transformations are supported by sorted input.

- By implementation of these transformations the session performance will increase.