Capgemini interview question

Different transformations,SQL queries and Scd types along with session properties.