Is there a way to split my response to multiple tables in target , I have a json which has multiple datasets I want to store then in different tables rather than in 1 table . is transformation with dbt right way to do it or we have something in Meltano to get this split

Depending on the specific JSON source you have, parent-child streams or stream maps might be ways to do this

This is a Single response I get from a API call , I want to store timeseries in table A , users in table B and so on , parent child streams are for nested API calls right and Stream map will still be mapping this data to same table , or am i missing something