Datastage interaction with Teradata in Immediate mode
I am trying to understand how Datastage interacts with Teradata in Immedaite mode. During my testing, I created a Datastage job with TD connector as source and destination to just select from one table and load into another table.
The load operation is in immedaite mode. So once the job is complete, I queried DBQLogtbl to see how the insert query is sent to Teradata from DS. It used a different format of query as below