Hi all,
my source is oracle ! i want to create shared conatiner for orcale ..
i have done shared conatiner for flat files .
but im getting confused creating shared container for oracle stage
example :-
select salray,basesalary from emp where dept = 10 and age = 30.
here i have 3 columns in oracle stage salary,dept, age
4th one basesalary that i had added in output column.
i have created shared container for this example XXXS
this i want to use in another job.
how to do this !
how to create shared container for oracle
Moderators: chulett, rschirm, roy
how to create shared container for oracle
In Adv Thanks
---------s
---------s
A shared container is DataStage's way of doing what a compiled language does in subroutines. It does not make sense to make a shared container, or even a normal container, for a source read stage unless the exact same query with the same columns and parameters is used everywhere.
The documentation is pretty clear with examples of shared containers, have you looked at it?
The documentation is pretty clear with examples of shared containers, have you looked at it?
Re: how to create shared container for oracle
I got ..........i was bit confused but atlast i did it
thnks all
thnks all
sekr wrote:Hi all,
my source is oracle ! i want to create shared conatiner for orcale ..
i have done shared conatiner for flat files .
but im getting confused creating shared container for oracle stage
example :-
select salray,basesalary from emp where dept = 10 and age = 30.
here i have 3 columns in oracle stage salary,dept, age
4th one basesalary that i had added in output column.
i have created shared container for this example XXXS
this i want to use in another job.
how to do this !
In Adv Thanks
---------s
---------s