Hi,
my source is oracle database in that for some fields data type is varchar2.
when i am importing meta data in oracle oci stage in datastage what i have to mention data type in data stage(for varchar2 equivalent datatype is varchar or someother)
Why you want to manually give it?
You can import metadata through Orchestrate Schema definition utility of datastage and load the same metadata at oracle stage.
Why you want to do it manually?
You can import metadata through Orchestrate Schema definition utility of datastage and load the same metadata at oracle stage.
Hi,
I have one table product in oracle database.i have to take this one as a source.how we wil get Orchestrate schema defination. After executing job we wil get orchestrate schema defination from dsx file.before how we will get OSH schema
vinsashi wrote:Hi,
I have one table product in oracle database.i have to take this one as a source.how we wil get Orchestrate schema defination. After executing job we wil get orchestrate schema defination from dsx file.before how we will get OSH schema
Thanks
....
No you don't have to take from .dsx file.
When you go on Import Table definition menu there you will find Orchestrate Schema definition utility
use this to import definition and store it in repository.
Then at oracle stage Load this metadata from repository when you are in column tab of oracle stage.
Hi ,
I have imported that one from osh schema defination.is any differnce when importing metadata from plug-in metadefination and osh schema
Thanks
v..
Some will tell you the OSH route is 'more accurate' but I don't see how an OSH schema will help you in a Server job, for that importing via the Plug-in Metadata option with OCI is fine. If you like, compare the two and see what (if any) difference there is.
And yes, Varchar covers string fields, including VARCHAR2.
-craig
"You can never have too many knives" -- Logan Nine Fingers