How to transform data from rest message to target table

Kishor O
Tera Sage

‎11-21-2023 05:21 AM

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

0 Helpfuls
  • 372 Views
3 REPLIES 3

AshishKM
Kilo Patron
Kilo Patron

‎11-21-2023 05:28 AM

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


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls

Kishor O
Tera Sage
In response to AshishKM

‎11-21-2023 05:47 AM - edited ‎11-21-2023 05:47 AM

@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)

0 Helpfuls

AshishKM
Kilo Patron
Kilo Patron
In response to Kishor O

‎11-21-2023 08:55 AM - edited ‎11-21-2023 08:56 AM

Hi @Kishor O 

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

AshishKMishra_0-1700585759164.png

 

 

-Thanks,
AshishKMishra 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls