DSXchange

Hi, I am quite new to Parallel Routines, I created a parallel routine and when i compiled the same in my transformer in parallel job i got the following compilation error "Extrenal function library path name cannot contain spaces". Please find the details of how the routine was created... ...

Hi, Guys, i am finding a bizzare error in prod. The error is when i load to a TeraData Enterprise stage. I am not able to identifty the reason for this behavior. Error Message: - "TeraUtils:DB Call Failure(success check) Info = 1, Code = 3706, Message = Syntax error: expected something between ...

Hi, This is the first time i am trying to execute the dsexport command. I was figuring out, is thery any way i could export only 4 jobs/sequencers under the same dsx name ? I used the below command as mentioned in Manager Guide dsexport.exe /H hostname /U username /P password /O omitflag project pat...

Nope. My stream link is odbc and reference(lookup) link is Seq File.

Sure I will let you know by today. I would build my job from scratch and investigate the issue.

Roy, The job is pretty much simple. I have a ODBC Enterprise stage, where i have a char(5) column and a sequential File stage that also has a char(5) column. I havent changed the preserve partioning tab at all in my job, Both the odbc (stream) and seqFile(reference) goes to a look up , In the lookup...

Hi, I have a odbc enterprise stage as a stream link to a look up stage and sequential File stage as a reference link to a look up stage. In the lookup stage there are no constraints or conditions, i had set the Lookup Failure option to Drop I had left the partitioning option to auto on both the stre...

Guys, I have a job which does the following. SeqFile --> (copy - Aggregator), (copy -- linkedsort) ---> Joiner -- > DataSet. The SeqFile is having around 10,00,000 records , In the Aggregator stage i am performing Aggregation type : CountRows based on the keys (AcctId,CustId). I had set the Group Me...

Hi, I am using Compress & Expand Stage for Datasets, since we have do not have much space in server. But ini using that when we compress a Dataset using Compress Stage and then in the subsequent job when we use that compressed Dataset followed by Expand Stage. Then in the output from Expand Data...

thanks ray and kim, kim: you were right, i actually appended the jobs + sequencers. while importing the jobs+sequencers duplicate error was not raised, the only thing that kept me irking was when i actually did the import selected jobs,it showed me there were duplicate jobs present, while importing ...

Hi,

I was trying to migrate few jobs and sequencers from development to testing environment from Manager. There are around 10 jobs + 7 sequencers, i imported a job twice (Append Mode) by mistake.

Is there any way i could remove the duplicate job ?

Hi, I have a scenario where my source file has a amount column CLAIM_AMT. The amount column comes as $100.00 in my source file, The source file is a csv file. I need to multiply the CLAIM_AMT by 20 and load it to the target, so is there any way i can remove $ symbol when i read my source , instead o...