DSXchange

Hi, I am facing problem with oracle truncate & load. My source is coming from one database and target is another database. The tnsnames entries for two databases were stored in same directory ds_home. Eventhough I am getting error: Write mode failure. But I have tried to load the target by the s...

Hi, please any one clarify me, Is there any difference between a normal Ds job and web services used Ds job means performance wise. Because my currenta scenario like to get the reference data from one main database I have to use web services. The main database contains millions of records. Previousl...

Hi, How to import the views metadata using Orchestrate method. After supplying all the database credentials , when I use browse option to import the meta data of a view. But it is always displaying tables only. To import view meta data should I enable any option or any another method. Advanced thank...

The Open/Close command are used to execute the Sql statements before/after loading the target tables like truncate tale etc... . To execute the stored proc use unix shell script & call that procedure in sequence by using Execute Command activity stage.

Regards
Suresh

Hi, I am executing Job sequence, which loads the data from one staging area to another staging area. Both Source and Target are Oracle tables. The sequence aborted and I am getting the following errors ORA-01034: ORACLE not available ORA-27101: shared memory realm does no. I have run the same job in...

Hi

Try with below logic
If Trim(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)='' Then setnull() Else StringToDecimal(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)

Otherwise use stage variable to check the column value is null or not

Please correct me If I am wrong

Thanks
Suresh

Hi, My job is simple load job loading data from Soure to target. Both source and target are oracle tables. I am loading the target by using RCP. The source table having 176108 rows. After loading 169678 rows I am getting the following warnings. Oracle_Enterprise_0,0: signalHandler__Fi() at 0xd2f4ff0...

Hi I am facing problem with Load option while loading from source table(oracle 10g) to target table (oracle9i). I have selected write method as load & truncate. In this situation job got aborted and returned the error sqldr 256. But the same job tried with insert option. The job was successfully...

Hi Chulett,

Oracle 9i

Thanks
Suresh

Hi Chulett,

Oracle 9i

Hi, How to import the oracle table having a column with long data type. The source sysem is already existing system so it could not possible to change data type now. I am getting the following error: Caught ORCHESTRATE exception in main program: APT_ParseError: Expected identifier; got: <eof> Could ...

Hi Mark, I am facing the same problem while loading data into oracle table. I got the solution from previous posts. Add the Environmental variable $APT_ORACLE_LOAD_OPTIONS and give the default value OPTIONS(DIRECT=FALSE,PARALLEL=TRUE). If this solution is wrong please correct me, but my job was succ...

Hi, Any one clarify me, which is the best method to import meta data i.e. Orchestrate method or Plug-in method. Because I am unable to import the table using Orchestrate schema definitions, but the same table imported using plug-in meta data schema definitions method. I am getting the following erro...

Hi,

Instead of SetNull() function try with default value like'0001-01-01'.
Please correct me if I am wrong?

Regards
Suresh

Hi, Your DBA has to give the permissions to Datastage server. CREATE ROLE DSXE; GRANT SELECT on sys.dba_extents to DSXE; GRANT SELECT on sys.dba_data_files to DSXE; GRANT SELECT on sys.dba_tab_partitions to DSXE; GRANT SELECT on sys.dba_tab_subpartitions to DSXE; GRANT SELECT on sys.dba_objects to D...