Issue with ODBC connecor in Server Job
Posted: Sun Jul 15, 2018 6:06 pm
Hi All,
We have a job design in server where the same table is reading and writing and then reading, in 9.1 server we have a sparse lookup with ODBC enterprise stage with transformer but before that the same table will be writing the data and the written data is extracting in the next stage. But when we converted it to connector stage and introduces a hashfile in between transformer and connector, connector stage was fetching the data as soon as job starts. Why the connector was fetching the data and why not the enterprise is waiting till the previous stage loads the data.
We have a job design in server where the same table is reading and writing and then reading, in 9.1 server we have a sparse lookup with ODBC enterprise stage with transformer but before that the same table will be writing the data and the written data is extracting in the next stage. But when we converted it to connector stage and introduces a hashfile in between transformer and connector, connector stage was fetching the data as soon as job starts. Why the connector was fetching the data and why not the enterprise is waiting till the previous stage loads the data.