DSXchange

Iam reading data from sequential file. Data in sequential file is a comma delimited, final delimiter is end, double quoted. Issue here is one of the field contains value like this "1905 E COUNTY RD "D"" . While reading data these records are getting dropped. Please help me out th...

Hi,
main_program: Internal Error: (destConcField->fixRunAnchor_f): api/transfer_rep.C: 1414
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH

When I execute the job Iam getting this error.

requesting to provied me with the solution.

Hi, In my job iam using two DRS stages as source and joining using joing stage and loading to a table using DRS stage. Compilation is successful but the job is aborted and iam getting a fatal error as Dynamic_RDBMS_15,0: Internal Error: (inputDS < inputLinks_.size()): dscapiopRep.C: 1212 Traceback: ...

The table exists, I have given permissions also.

Hi All, I have two instances for source(CLMGMDDB) and for target(GMSOWNER). For this iam using oracle enterprise stage as both source and target. Its compiling successfully. But job execution is aborted because of this error. Oracle_Enterprise_10: Write mode failure: SRVC_TEST does not exist. I have...

Hi, I have a job with oracle enterprise stage, transformer and a sequential stage. When I execute the job, job is aborted and in log I found this error. Transformer_22: Failed to load the library "V0S22_Untitled1_Transformer_22.so"; either the directory containing the library file is not o...

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs ORACLE_HOME=/u01/app/oracle/OraDb10g_home1 export ORACLE_HOME ORACLE_SID=DSREPO export ORACLE_SID LD_LIBRARY_PATH=/home/dsadm/Ascential/DataStage/PXEngine/lib:/u0...

sorry to say 'fresh' its new installation.
sorry to ask a siily question but we have installed the oracle 10g db server and datastage 7.5.3 on the same linux box. even then do we need to put client on the machine.

thanks in advance

Hi, Its a fresh installation, from oracle enterprise when I want to view data, iam getting this error ##I TOSH 000002 18:23:04(001) <main_program> orchgeneral: loaded ##I TOSH 000002 18:23:04(002) <main_program> orchsort: loaded ##I TOSH 000002 18:23:04(003) <main_program> orchstats: loaded ##I TFSC...

We have transformation rules also. what I want to know is about the Hardware configuration and that server concurrently should be accessed by 20 developers and all the 20 developers will be using 5TB of data and also applies some transformation rules. sources are sequential files and target is oracle

We have transformation rules also.

what I want to know is about the Hardware configuration and that server concurrently should be accessed by 20 developers and all the 20 developers will be using 5TB of data and also applies some transformation rules.

Hi,

Source data is having 5 TB of data.

What should be my server hardware config.

OS : 2003 server, I need other details.

Thanks in Advance

Sequential file properties -> format -> Record level -> Record Delimiter String = DOS Format.

and also

Sequential file properties -> format -> Record level -> Final Delimiter = end

Please provide sample data.

Hi All, I have installed datastage 7.5x2, when I used Oracle enterprise stage and when I want to view data iam getting this error. ##I TFCN 000001 23:15:10(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Rese...