Infosys ETL Developer Interview Questions, Process, and Tips

Mapping is the process of defining the relationship between source and target data in ETL.

• Mapping involves identifying the source and target data structures.

• It also involves defining the transformation rules to be applied to the source data.

• Mappings can be simple or complex depending on the complexity of the data.

• Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target

Session refers to a period of time during which a user interacts with a computer system or application.

• A session is created when a user logs into a system or application.

• It is used to track user activity and maintain user-specific data.

• Sessions can be terminated manually or automatically after a certain period of inactivity.

• Session management is important for security purposes.

• Examples of session management techniques