Talend : running multiple SQL statements using database row component (example aws redshift tRedshiftRow)
Problem - You might need to run more than one statement in tRedshiftRow (or any other database Row component in talend).
Solution - You can do this by writing your statements in a single string separated by the statement separator for the DB you are using for redshift its ; and i guess for most its the same.
I majorly issue vacuum and analyze commands for my db tables as last job of my load.
example below - just below sql in tREdshiftRow component and it will execute it as multi-statement sql.
"vacuum table1;
vacuum table2;
vacuum table3;
"
vacuum table2;
vacuum table3;
"
Very impressive and very useful post, thank you for sharing with us. Know more about talend online trianing
ReplyDeleteGreat thoughts you got there, believe I may possibly try just some of it throughout my daily life.
ReplyDeleterpa Training in Chennai
rpa Training in bangalore
rpa Training in pune
blueprism Training in Chennai
blueprism Training in bangalore
blueprism Training in pune
rpa online training
Set aside my effort to peruse all the remarks, however I truly delighted in the article. It's consistently pleasant when you can not exclusively be educated, yet in addition, engaged!
ReplyDelete360DigiTMG Data Analytics Course
wonderful bLog! its intriguing. thankful to you for sharing.
ReplyDeletedata science certification
Truly overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. Much obliged for sharing.Best data analytics course in Hyderabad
ReplyDeleteYour amazing insightful information entails much to me and especially to my peers. Thanks a ton; from all of us.
ReplyDeleteBest Data Science Courses in Hyderabad
Nice blog. Found this while searching through
ReplyDeletedata analytics course in aurangabad