Continuously Read data from Oracle

[ankursaxena.2003]

Hi,

I have an MQ Job which reads data from Queue and then does a LKP on table A and then writes into table B. Table A is being populated by some other system in real-time.

Table A
|
|
|
MQ ------------------ LKP ------------------ Table B

Question: System will put message in MQ and other system will insert a row into Table A. And I have to get few columns from Table A. So I would like my datastage job to read the new record inserted in Table A.

I am using Oracle connector to read Table A.

[chulett]

Not really seeing a question... but it sounds like you just need to use a sparse lookup.

[ankursaxena.2003]

Basically I want to dynamically read data from Table A.

My MQ job will be running continuously so if a record is inserted in table A, then my job should read that new record immediately in job.

[chulett]

Same answer.

[ankursaxena.2003]

Thanks Craig. It worked.