SQL query extraction from oracle stage
Posted: Mon Mar 11, 2013 8:55 am
Hi Team,
I had encountred some problem in datastage oracle stage.
I have query as below
Select * from table A
where id in (select id from table a)
and
id in (select id from table b).
I used the above query to extract the data from oracle database,while runing the query using toad ,i am getting some 129000 rows,But when i run the same thing using datastage some time i am getting 129000 but some time i am getting 116000 or so. I analysied the issue and found that it may be beacuse of the array size which we defined in oracle stage.Please correct me if i am worng and let me know if you have any suggestion to trace the issue. I modified the query as below and run in toad and datastage i am getting the correct results.
Select * from table A
where id in (select id from table a where id in (select id from table b)).
I am using 7.5 Server Edition and my database is oracle and datastage server is UNIX.
I had encountred some problem in datastage oracle stage.
I have query as below
Select * from table A
where id in (select id from table a)
and
id in (select id from table b).
I used the above query to extract the data from oracle database,while runing the query using toad ,i am getting some 129000 rows,But when i run the same thing using datastage some time i am getting 129000 but some time i am getting 116000 or so. I analysied the issue and found that it may be beacuse of the array size which we defined in oracle stage.Please correct me if i am worng and let me know if you have any suggestion to trace the issue. I modified the query as below and run in toad and datastage i am getting the correct results.
Select * from table A
where id in (select id from table a where id in (select id from table b)).
I am using 7.5 Server Edition and my database is oracle and datastage server is UNIX.