You are developing the PDI solution for a customer. The customer requires that a set of SQL statements are executed on each connection to the database.
I'm not sure about the other options, but using the Advanced section in the Database Connection window to enter the SQL statements seems a bit clunky. C looks like the cleanest solution.
Option C seems like the way to go. Passing the SQL statements as a parameter in the Database Connection window's Options section is a pretty straightforward approach.
Isadora
2 months agoDaren
18 days agoLuis
21 days agoLavelle
27 days agoDanica
1 months agoHerschel
2 months agoReita
2 months agoJennie
28 days agoMadonna
1 months agoBrice
1 months agoTwana
2 months agoLudivina
2 months agoJoesph
27 days agoLigia
1 months agoJanna
2 months agoStephane
2 months agoAfton
2 months agoSharee
3 months agoHerschel
3 months ago