Lookup
Posted: Mon Sep 25, 2017 3:20 pm
Hi,
In server job I would like to understand the difference between doing the lookup using colon or bind variable and doing without using colon or bind variables.
Job1:
Reference stage: Oracle Connector
Reference sql: Select ABC, DEF FROM XYZ;
Using ABC as Key column in the Oracle Key in Oracle Connetor and in the transformer stage input link column and connected the key column in the transformer stage.
Job2:
Reference stage: Oracle Connector
Reference Sql: Select ABC, DEF FROM XYZ where ABC = :1;
In Job 1 Datastage extract all the reference data into the server and do the joining where as in Job2 for every input row reference sql will be executed like parallel job sparse lookup. Is my understanding correct? Please advise.
Thanks & Regards,
Poovalingam.
In server job I would like to understand the difference between doing the lookup using colon or bind variable and doing without using colon or bind variables.
Job1:
Reference stage: Oracle Connector
Reference sql: Select ABC, DEF FROM XYZ;
Using ABC as Key column in the Oracle Key in Oracle Connetor and in the transformer stage input link column and connected the key column in the transformer stage.
Job2:
Reference stage: Oracle Connector
Reference Sql: Select ABC, DEF FROM XYZ where ABC = :1;
In Job 1 Datastage extract all the reference data into the server and do the joining where as in Job2 for every input row reference sql will be executed like parallel job sparse lookup. Is my understanding correct? Please advise.
Thanks & Regards,
Poovalingam.