DSXchange

Resist silly requirements. Either you're migrating the OWB code into DataStage or you're not. Which is it? You have version 8. Therefore you have the DataStage SCD stage, which can do both Type 1 ... Ray, Thanks a lot for your explanation. Even if i implement stored procedure logic in datastage, i ...

Thank you very much for your reply.

If i give lookup failure property to continue then that will be a left outer join.

I have a number of reference tables (number of records few) and i want to join it with a source table. I need to right outer join with the reference tables.

Yes. I have tried it. But still getting the same deadlock error

Hi,

Could you tell me how can we implement right outer join in lookup stage?

Thanks in advance..

Thanks for your replies.

Target table is different from source table. No index on target table.

But one stored procedure (which will refer the target stage) is used before the target stage

Hi, I have 9 million records in my source table. When i tried to load all the records then i got the following error: Array execute failed for insert: qlcode is: -60 esql complaint: ORA-00060: deadlock detected while waiting for resource When i filter for 50 records in the source then the job runs s...