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
14 days agoLuis
17 days agoLavelle
23 days agoDanica
1 months agoHerschel
2 months agoReita
2 months agoJennie
24 days agoMadonna
1 months agoBrice
1 months agoTwana
2 months agoLudivina
2 months agoJoesph
23 days agoLigia
27 days agoJanna
2 months agoStephane
2 months agoAfton
2 months agoSharee
2 months agoHerschel
3 months ago