If a transformation has many Insert statement in the table. How can we know which insert query is running in the execution log if the transformation is running as a job.
Hi @praveen.ojha12 ,
You should see in the transformations section a column called Enabled, if there's a yes then it's running. You can activate or disable transformations at your liking. From the Data Job then in logs you can see which transformations ran.
Hello @1460067637 ,
I don't mean that.
Let me explain myself with a scenario-
Let's say I have a transformation named "Test", and there are many queries inside the transformation as shown in the screenshot below:
Now if I execute this transformation, I will see below execution log:
But say if we have queries that go on for a long time. Then how to know which query is running from execution log.
Hello @1460067637 ,
I don't mean that.
Let me explain myself with a scenario-
Let's say I have a transformation named "Test", and there are many queries inside the transformation as shown in the screenshot below:
Now if I execute this transformation, I will see below execution log:
But say if we have queries that go on for a long time. Then how to know which query is running from execution log.
Hi @praveen.ojha12 ,
Now I understand, there's no way as far as i know to know which exact query is running from the log.
If you have problems tho with a specific transformation you can run singular query into the transformations and see which one is taking long by selecting the query and running it with CTRL+ENTER.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.