Hello,
I am working on a request to provide all level of parent values for each individual child value. It is kind of bottom top approach. I have to start from a child ID column. For each child I need multiple cols of Parent ID. Something like below:
The current data looks like
I am trying to solve this in ETL. Any suggestions how to plan ETL? TIA