Page 1 of 1
Transformer lookup on ODBC reference links
Posted: Fri Sep 30, 2016 12:41 pm
by syedmuhammedmehdi
Hi, I'm converting a server job to parallel job. In server job a file is read and using transformer stage a lookup is done on DB using ODBC stage. My query is if there are multiple records in DB for an input record whether multiple records will be output or any random sigle lookup will be done and only one record will be the output?
Posted: Fri Sep 30, 2016 1:06 pm
by chulett
That's an option for ODBC (and UV), there is a "Return multi-row result set" checkbox on the link, from what I recall.
Posted: Fri Sep 30, 2016 4:08 pm
by ray.wurlod
Why aren't you converting to use the Lookup stage for lookups?
Posted: Fri Sep 30, 2016 4:09 pm
by chulett
I'm assuming they are but wanted some clarification as to how they work on the Server side.