Prepare a data pipeline design to ingest data from transactional $($aka OLTP$)$ system into

data warehouse by showing visual representation of your data pipeline, along with explanation of the

same. You can consider that data needs to be ingested every $30$mins from OLTP systems to Data

Warehouse system into the final tables designed in previous questions using ELT technique. Please

note that Data pipeline should clearly articulate clearly tables being read from transactional system

$($you can assume and consider any table name$/$structure from transactional system$)$ and how that data

will land into final reporting tables for meeting reporting needs as mentioned in this use case but

should consider either Star or Snowflake schema of data modelling showing tables in which data will

be inserted and should also make use of staging tables. $[6$ Marks$]$