DataFlux SQL Lookup

[Che]

Hello,

I have 2 questions below related to DataFlux Data Management Studio 2.6

1. Is it possible to specify AND condition on multiple data elements or fields in SQL lookup e.g id=id1 and status=status1
2. I have a data job which has 10 SQL input nodes(runs same SQL) which selects data from 10 different schemas and has same table structures. During testing, I need to just run one node vs all 10 nodes, is it possible to exclude 9 nodes from execution and run only one input node? This is needed to test job which deals with higher volume of data. 

Please let me know if you have any questions and need additional information.

Best regards,

Chetan

[VincentRejany]

Hi



If you need to build more complex SQL Lookup you can use the "Parameterized SQL" node, ie Select description from mylist where id = ? and version = ?". Next the parameters have to be passed in the exact same order.