DSXchange

Hi, I have a job developed in 9.1 Parallel versioin. Job design is Dataset -> Trf -> Ora Connector. Updating target table which contains 11mn records from Dataset(Dataset also contains same no of records as Fact, its a replica). The table has constraints, tablespace and partitions created on it. Its...

Hi All, My job contains three stages OraOCI -> Trf -> OraOCI, when I run the job, it got aborted and throwing a Fatal error as SRC_STG_PRMMYINVOICE_NEW..FLTR: %s Here FLTR is trf stage name. I have searched in the forum but could not find any help on this issue(%s). I am working on DataStage 9.1 ser...

Hi, We are building the Cognos cubes(unix script will build the cube) thru Datastage execute command activity. We designed the sequence job to trigger the unix scripts(which will build cube in cognos server) parallelly. But when we run the sequence job, it is triggering the scripts sequentially. Seq...

Hi, I have a simple one to one mapping job is taking long time to run. My job design is OraOci -> Trf -> OraOCI. To Process 4440 records it took 30mins and the other day it took 58 mins to procsess just 125 records in Production. We have a user defined source extract query to pick the data based on ...

Hi All, I am using Command Acitivty in Sequence job, in that using ls command to listing the File. If it does not find a file in the mentioned path, its giving one warning message like Command ls -1 did not finish OK, reply = '2' . Because of the warning, sequence job getting aborted. I want to hand...

Hi All,

We have the amount value like 1000000.00 and need get the output as 100,000,0.00. Means need to seperate the amt value with Comma(,) after every three digits.

Can anybody help how to achieve this in datastage and my source column is Varchar datatype.

Thanks in advance.
RK

Hi, We are loading the data from dataset to Ora db(10g) table with WriteMethod as Upsert. The job got aborted due to the below error. oraDForecastMonthly: Indexes on table xxx.D_FORECAST_MONTHLY_VERSION' preclude direct parallel loading unless an index option is included. Add an index option or drop...

Hi Chulett,

we are using Oracle EE Stage as source and target. And we difined a environment variable at Project level and given the password to taht and using that variable as parameter in our job through Parameter Set. The password is defined in Encrypted mode.

Thanks in advance.

Hi Chulett, thanks for your reply.

My source and Target stages are Oracle db.

my job disign is like : Ora db stage->Transformer stg->Ora db stage

Thanks in advance.

Hi Friends, I got one issue with password seeting in paramter. When I ran the job, i got an error like Incorrect dboption list; it failed on Expected "," or "}", got: "@", line 1 I don't have any special characters in my password, using only characters and number like A...

Thanks for your reply Eostic.

I tried with one sample xml file, i was able to import through Load->XML Definition, but the metadata is not getting saved into repository. How can I save the metada and load the same into my Columns Tab in Output page.

appreciate your help.
Thanks in advance.

Hi, I am using XML stage first time. Please correct me If am wrong. We are loading xml data which is existing in Oracle table in a single col as LOB, and using XM Input Stage to pick the data from table and load XML data into Oracle table. I am trying to import col definition from XSD file(we have x...

Thanks alot Ray, Your logic worked out. I implemented this logic and its giving result. As you said, I took JAN_NAME, FEB_NAME and MAR_NAME columns in Transformer stage and populatied constant values like JANUARY, FEBRUARY and MARCH respectively, then used Pivot stage. Once again thanks to all who h...

Thanks for your Reply friends. Ray, i tried with your suggestion, but could not get proper output. will explain what I did exactly. source is : YEAR, JANUARY,FEBRUARY,MARCH 2009,100,200,300 etc.. Output should be : YEAR,MONTH,AMOUNT 2009,JANUARY,100 2009,FEBRUARY,200 2009,MARCH,300 I took col genera...

Hi, I have a different requirement. My input is like Year, JAN,FEB,MARCH 2010,100,200,300 and my Output should be like Year, Month, Amount 2010,JAN,100 2010,FEB,200 2010,MARCH,300 I tried in this forum, but could not find the relevant solution. Please throw some light on this issue. Thanks in advance.