About sathyan75

sathyan75 · 06-01-2022

Is there an option to build a query using variables. I have the table names in a lookup table and i would like to use that to build dynamic SQL in Incorta. Is there such an option available in Incorta?

sathyan75 · 04-01-2022

I have a table that I am loading from Salesforce. Salesforce purges the deleted records after 15 days. However, I would like to retain these records in Incorta. Whenever a change is made to the underlying salesforce object, and we include those field...

sathyan75 · 06-01-2022

We have 30 different tables and each of these table names are in a look up table column. I would like to run through a loop wherein each of these table names are fetched from this lookup table and we create a dynamic select query on this table name a...

sathyan75 · 04-06-2022

Hi RADSr, thanks for that. 1) I am not aware of how many new columns are going to be added. It keeps happening and changing.2) Same here, I cant keep creating new tables for every change that is happening.

sathyan75 · 04-04-2022

Hi Ahmed, Thanks for your response. My scenario is that I am adding new columns and there are new rows as well but I dont want to lose the old rows too. How to handle this?

User Statistics

User Activity

Dynamic SQL

Schema full load after changes

Re: Dynamic SQL

Re: Schema full load after changes

Re: Schema full load after changes