DSXchange

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.

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

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.

Same answer.

Thanks Craig. It worked.