how to create a staging table

Question

hii all 
 im new to appian, please tell me 1.how to create a staging table , 
 2.and alos how to clear the staging tables 
 3. how to write staging table data to main data table using script task

Harshit Bumb (Appyzie) · Answer

1. Staging table is just like any other table but the difference is that we do not treat it as the main table. 
 2, 3. You can write the data to the staging table based on your use-case. If it has a primary key column, then you can write it via Write to DSE but if it doesn't have a PK (importing excel to DB) then you can use the smart service. And based on the same question, you can decide which way to clear and populate the main table. Either use delete from DSE smart service, or run a SQL query using a Smart service or create an SP.