We all know that it is possible to print the Insert statement generated by database output components (say tMsqlOutput) by enabling option "Enable Debug Mode".
In my job, i am using Extend Insert option (refer screen for details).
My question is , If 100 records are the source , due to this Extend Insert Configuration I am expecting the talend will generate only single insert statement with 100 records (because of auto extent) but I see individual insert statements for each output records.
Can anyone help on this , printing the actual query generated in Extend Insert/ Batch mode.
Thanks in Advance..
For t<DB>output component, there is only a global variable QUERY which is the query statement processed. This is an After variable and it returns a string.
Can u please tell me how to get the insert scripts from source like as txt,csv,xlsx .i need .sql file as output which have insert scripts.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.