DSXchange

Vincent Can you please be more specific. Do you mean to create two target transofrmers, one for inserts and one for updates. Currently, I have one transformer with the target columns include CREATED_DATE, UPDATED_DATE, CREATED_BY AND UPDATED_BY. I have set the Action type to insert new rows or updat...

Thanks for everyones input.

I was able to resolve the issue with help from Ascential

I had DS 7.1 running on Solaris and Oracle 9i. The $ORACLE_HOME/lib needs to point to 32 bit in dsenv file under DSHOME. This is a prereq. when using DRS and OCI9I stagetypes

Thanks for everyones input.

I was able to resolve the issue with help from Ascential

I had DS 7.1 running on Solaris and Oracle 9i. The $ORACLE_HOME/lib needs to point to 32 bit in dsenv file under DSHOME. This is a prereq. when using DRS and OCI9I stagetypes

I have installed DS 7.1 on a solaris test box as non-root. I ran the services and impersonsation files to create the rpc service and give the DS adminstrator user the previleges to stop and start DS. This works fine. I installed the same as an user that can sudo to root on another solaris box(QA BOX...

Guys - I applied another boolean but still doesn't work ( (NOT(IsNull(DSLink3.NEWCOLA)) OR NOT(IsNull(DSLink3.OLDCOLA)) OR NOT(IsNull(DSLink3.NEWCOLB)) OR NOT(IsNull(DSLink3.OLDCOLB))) ) AND ( DSLink3.NEWCOLA<>DSLink3.OLDCOLA) OR (DSLink3.NEWCOLB<>DSLink3.OLDCOLB) ) Thanks for everyones input

I have the $ORACLE_HOME defined in the dsenv file. When I use the DRS stage, I am getting the following error

TEST1..Dynamic_RDBMS_17: Could not load drsoci.so
TEST1..Dynamic_RDBMS_17.DSLink1: DSP.Open GCI $DSP.Open error -100.

Thanks for your response

I am getting the following error Unable to initialize plug-in:

in the designer. I am using OCI9i and DRS stages. Please help!

Here is the situation: There following four columns are being read from the source side. I have created a constraint on the target transformer to only write the records if any of the column is not null (NOT(IsNull(DSLink3.NEWCOLA)) OR NOT(IsNull(DSLink3.OLDCOLA)) OR NOT(IsNull(DSLink3.NEWCOLB)) OR N...

Guys Here is another situation. I have created a Hashfile lookup in one of my mappings. In the source master query, the following are the columns: OLDCOLA, OLDCOLB, OLDCOLC, NEWCOLA, NEWCOLB, NEWCOLC, I was able to manage the OLD AND NEW VALUES BY APPLYING TRIGGERS AT THE DATABASE LEVEL OLDCOLA AND ...

Guys, I have the following scenario : Target Table (TABLE A) has the following 4 columns, the KEY column and few other columns Column_Name TYPE CREATED_DATE DATE CREATED_BY CHAR UPDATED_DATE DATE UPDATED_BY CHAR Now, for above columns I am trying to comeup with an CONDITIONAL INSERT/UPDATE logic. ON...

Guys, I am having some hard time setting up the constraint at the transformer STAGE on the TARGET STAGE/LINK. In the Contraint Window of the target transformer, I have created a constraint something like this: DSLink3(SOURCE LINK) If (DSLink3.COLUMN1=@NULL AND DSLink3.COLUMN2=@NULL AND DSLink3.COLUM...

Thank you for the valuable input.
I appreciate it!

Let me try to explain with an example on what I am trying to accomplish. I am using DRS stage type(similar to OCI STAGETYPE) FOR READING/WRITING DATA FROM/TO SOURCE AND TARGET TABLES. I am reading data from the SOURCE TABLE (TABLE X) and trying to LOAD into JUST ONE TABLE (TABLE A). The UPDATE ACTIO...

I have a situation where I am loading data to TABLE A (Parent table). The Job has the UPDATE ACTION AS 'UPDATE EXISTING ROWS AND INSERT NEW ROWS'. If the record is being updated I need to load the MATCHING ROW (KEY=KEY) before UPDATE into a HISTORY TABLE (TABLE B) and then UPDATE THE DATA IN TABLE A...

For a test project I created the following UserDefined Environment variables using Administrator SRCServer SRCPassWord SRCUserName TGTPassWord TGTServer TGTUserName In the Designer I am calling the above variables in one of the jobs #$SRCServer# #$SRCUserName# #$SRCPassWord# #$TGTServer# #$TGTUserNa...