How to transform data from rest message to target table

[Kishor O]

I created a scheduled job and parsed json response then I inserted the record to the staging table.

Now I want to transform the records into target table How can I do it.

*Should I need to create a data source if yes what should be the data source type

[AshishKM]

Hi @Kishor O ,

You should write a BR on staging table and process the record for inserting in target table. 
If this is not the case then explain “how scheduled job reading the JSON dynamically from where”.

-Thanks,

AshishKMishra

[Kishor O]

@AshishKM 

I wrote get rest message directly in the scheduled job then glided the staging table and inserted the record.

(staging table extending import set table)

[AshishKM]

Hi @Kishor O 

You have source & target table, you can create transform map. What's issue with that. 

-Thanks,
AshishKMishra