DSXchange

Both DS Server and Oracle Server are installed on the same machine. Do I still need to install the Oracle client again on the same machine. Can you pls clarify?

Thank you

Satish

I have a IS 8.5 installed on Win 2003 server and its a 64 bit. Even IS is 64 bit. When I tried to run an job with Ora Enterprise stage, it is failing in validation. This is the error I am getting: main_program: PATH search failure: main_program: Error loading "liborchoraclent": Could not l...

I am sorry for posting it in the wrong section. It is a parallel job.

I have 4 pipelines in a job. Each having separate SRC and TGT. SRC1 --> DSStages--> TGT1 SRC2 --> DSStages--> TGT2 SRC3 --> DSStages--> TGT3 SRC4 --> DSStages--> TGT4 Is there a way where we can tell datastage to execute these pipelines in a particular seqeunce like 1,2,3 and 4. I know its possible ...

Oracle table is not partitioned. I realized that I added a property called 'partitioned table' in the Ora stage and that was causing the issue. Thanks.

Getting this error when I am trying to read data from an Oracle table. >##E IIS-DSEE-TDOR-00299 11:38:17(001) <STG_ED_INDV> APT_OracleRowid8PartTable: failed to get the block count. >##E IIS-DSEE-TDOR-00195 11:38:17(002) <STG_ED_INDV> Errors were encountered partitioning table stg_ed_indv_eligibilit...

I also had the same issue and I spent a great deal of time trying to get a solution. Finally I figured it out. This is what you need to do. 1. You should do all the lookups in the stream and so that will be a range 2. Build a reference in the following way: Key Field1: 7 Key Field2: 7 Start Date: 20...

Kunal - Can you pls clarify what you said? I did not understand u.

Yes Craig. Thats exactly what is hapenning.

I should have provided this earlier: Stream Input: A Case, Emp, Action_DT ------------------------- A100, 100, 1/1/2010 A100, 101, 2/1/2010 Reference Input: B SK, EMP, E_ST_DT, E_END_DT, O_ST_DT, O_END_DT ------------------------------------------------------------- 1, 100, 6/1/2009, 4/1/2010, 4/1/2...

I am trying to build a range lookup. This is done in the stream. I have 3 different range key expressions specified. 2 of them are based on dates and another is based on an integer number. Having a weird issues. When I try to perform the lookup with just few records (like less than 50), the lookup p...

The reason, I do not want to handle the comparision using DB is the volume is huge. Day 0 load will be close to 80 mil and every 5 mil incrementally. But, I will sort it using DB. Will try using Stage variabls and see how it goes.

I have a data from src like this: ColA, ColB 100, ABC 100, ABC 100, DEF 100, DEF I want to tag a new column like below: ColA, ColB, ColC 100, ABC, 1 100, ABC, 0 100, DEF, 1 100, DEF, 0 I know that this can be acheived through Sort stage with the CreateKeyChange option. There are more then 50 Mil rec...

No - there will not be 2 rows which will update the same dimension row. Let me try that option and see if it works.

FYI - I was working with 10 records.