Hi,
I have around 50 SQL statements which needs to run one after the other and write the data to its respective tables.
I have created a workflow where it passes around 40 SQL statements and its Target_SQL_Tablenames to a batch macro. I am using In-DB tools as each table has millions of records. As our company doesn't allow Gallery connections for In-DB tools, I created a .indbc file to store the connection.
Batch macro takes first SQL query as input to extract, transform and write data to Target_SQL_Tablename.
I ran the workflow with a where condition in the SQL queries restricting number of records for each table to 100 and it was successful. But when I run it for all records, it writes data to the tables successfully but doesn't stop running.
Can you please help me resolve this?
Thank you
Koushik
