The source to staging transition will be of simple select and simple functions like cast, and case when statements using joins to join the two or more source table and inserting into the staging table. Its better to ask the ETL Team to share the scripts for better understanding.
... View more