Is there any replacement for Oracle OCI in parallel job? The table that is working with Oracle OCI in server job ...is not working with ODBC stage in parallel job. I have a problem with a column with a name "TIME_STAMP" for which the datastage is importing as LonVarBinary datatype instead of timestamp. When i changed it to datatype TIMESTAMP in server job, it is working.......but the samething i have done in parallel job...it is not working...saying that filed doesn't exist. I must do this job with parallel job...no other way.
i dont have select privileges on dba tables. They have given me the privilege only on the schema iam working. Is it necessary for orchbutil to have select privileges on dba or system tables?
Oracle's Date field has Timestamp portion in it. Datastage, has Date and Timestamp as different datatypes. You can pick the best close datatype for your requirement.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'