on 05-17-2009 5:00 AM
hello i have couple of questions and I am on Pi 7.0 and using jdbc lookup on sql table
1.can i map to a different source field from look up from one source field?
eg my source fields are S1 , S2 ,S3 ,S4 ,S5 S6 and i want to populate S4 from S1 and map it to target feld say T4.
I will be adding S1 S2 S3 S4 S5 S6 to target field T4.
lookup based on S1 on dbtable and get value into S4 and map T4 to target field?
is it possible ..any hints ...?
2.can i do look up twice on sql table using jdbc look up .
one call based on S1 and get S4 and S5 from table1 and map it to T4( T4 is always concat S1,2,3,4,5,6)
other call basd on S1 and get count S6 from table2 and map it to T4
thanks for reading
1.can i map to a different source field from look up from one source field?
No.
i want to populate S4 from S1 and map it to target feld say T4.
If S4 is source field, then this is not possible. Map the values directly to target field. Or you may use the output of lookup UDF and use some funcitons further.
2.can i do look up twice on sql table using jdbc look up .
Yes, but that would mean multiple calls to JDBC table for each set of records. Make sure that there are no frequent calls otherwise it would hamper the scenario performance.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Points awarded and marked as answered.
thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.