DSXchange

I have ODBC stage -----------> copy stage-----------> filter stage the copy stage is simple, just to rename a field, but I found the input records number is more than output record name. Any idea why this happened? I also change the copy stage option face=true, than I got same problem. then I change...

Thanks, Ray, for giving me the direction. But I still need to know more details about that. I have tried diffrent setting/options on the Numeric decimal data type for 1 hour. I still could not get what I expected.

is there any other way to add the + sign in front of a positive number? I don't like to use string function to do that.

Hi, 1 2 3 4 Filename="test.dat" 5 Jobname="testjob" 6 scriptsdir="/usr/testdir" 7 scriptname="amt.ksh" 8 commd="ksh":" ":scriptsdir:"/":scriptname:" ":Filename:" ":Jobname:" ":"outputfile.dat&qu...

use oracle analytic function (Lag or lead)to get current state and next state, current start date and next end date partition by name order by date.
if current is equal to next, use current start date and next end date.
there will be a problem on formance.
any better idea?

Hey, I am using LOAD option in oracle enterprise stage. When i load onto the VARCHAR Field, the data is getting loaded with spaces. Example Assume the job as follows Oracle -----> Transformer------->Oracle In transformer i am defaulting a value "SM" for column "Code" of datatype...

the message is "JN_Debt_Follow_Up.LN_join_DataSet_Sort: When checking operator: Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0." what is explicitly repartition? how to explicitly repartition? Sorry, my q...

the message is "JN_Debt_Follow_Up.LN_join_DataSet_Sort: When checking operator: Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0." what is explicitly repartition? how to explicitly repartition? Sorry, my q...

I have some job, when the repartition has to happen, such as join key changed between one join stage to another join stage, it will give warning. Can anyone give me some guide how to avoid these warning message? (do not handle massage in director).
many thanks

It should work. I used few days ago. Check your format %yyyy-%mm-%dd

in transform set to input.field/1, convert null to '0' , set the output datatype to Decimal(5,3).
It will work

I do not think there is a simple way to do it. Just change it one by one, that will only take 2 days for one people.

I'm getting an Invalid character value for cast specification on this column: It's coming from a sequential file RATING_PUBLSHD_DT = "9/13/1999 0:00:00" I'm trying to insert it into sql server, as a timestamp. (23,3). Not sure why i'm getting an error on this for. I believe you format the...

I was facing one preblem. the merge stage process two files. all filds are direct writen to a new output file. something I do not understand is some field in source is null become others field's value in target file. if I replace the null with 'NULL' in source, 'NULL' will be writen in target file c...

chulett thanks for your advice. It did work . in the script I will run , just two commands. such as echo "helo world" touch HelloWorld.flg I made a very stupid mistake, I did define the directory the file should be created. when I could not find the file, I thought the script was not excut...