DSXchange

Hi,
Where i can find more information on partitioning except the manuals given by datastage.

To get more knowledge each stage wise and fine tune the jobs.
Thanks.

Hi,
it works for me after i implemented sort on the input link for all the keys.

Hi, i searched for this error but was not able to find solution. i am running my job on 4 node and its updating 1 million records. I am using oracle enterprise stage for reading and writing the data. I am reading same table in source and trying to update after dome transformation in target stage. OR...

Hi, In stage variable i counting number of rows. its running on 4 node. but the problem is i am getting not the total nu,ber of count i am getting count as on each partition: Output i am getting: 1,Rec1 1,Rec2 1,Rec3 1,Rec4 Expected result is: 1,Rec1 2,Rec2 3,Rec3 4,Rec4 Transfomer setting are: Part...

My uderstanding is that zero will generate that warning but then work as desired. Try it, let us know. There are two ORAUPSERT variables, make sure you don't have the TIME one set as well. That and make sure you're actually doing "upserts" rather than "loads". You never specifie...

A value of 1 would mean to commit every 1 record, i.e. every record as it is written. You either need to use a zero or some amazingly large number you'll never hit. If what you wrote is actually a negative one, that's not supported. If i set to zero i got below error: CTEST: The environment variabl...

Hi, I am using environment variable to control commit in my job. $APT_ORAUPSERT_COMMIT_ROW_INTERVAL where Min value : 2 Max Value : 147,483,648 but it is not working i kept the max value - 1 My requirement is when the job fails no record should be inserted in the oracle table. Here in my job i am ge...

Since, the source is a varchar field, wondering if you are geting any spaces or empty from it!! If so, you might get this error. Check this way - If Trim(NullToValue(out.AMOUNT,'0')) = '0' then 0 Else StringToDecimal((TrimLeadingTrailing(out.AMOUNT))) Please let us know the results. Already i did t...

Hard to tell without knowing your data. Keep edging it up till the problem goes away. You may need to increase precision also, if scale gets too close to it. ... Sample Data: 0.01 177.2412 327.67 0.01 195.04078125 208.04 191.353076923077 197.856666666667 203.63128113879 198.6475 282.325 0.008924731...

Your first value has 12 digits following the decimal placeholder, but your Decimal data type's scale only allows for 10. DataStage is alerting you to the fact that the least significant digits have p ... Ok so the problem is with my scale setting. But when i set scale to 14 also i got the same erro...

Hi, In my parallel job i am trying to convert the string value into decimal. I have below as input. 1. 178.870230769231 2. 0.01 3. 327.67 4. 177.2412 So for this conversion i am writing the code as: If IsNull(out.AMOUNT) Then 0 Else StringToDecimal((TrimLeadingTrailing(out.AMOUNT))) But i am getting...

Thanks nikhilanshuman ,
After adding it as $PROJDEF in sequence i am able to run the sequence.

Look in the log file for each run type (alone and from sequence) and see what's being passed as this parameter. Compare the values. Please also advise your exact version of DataStage. Hi Ray, From log file nothing can be found as it is showing the password in cipher form. For Sequence it is shown a...

ray.wurlod wrote:Did you make the environment variable Encrypted type? ...

Yes.It is Encrypted in all the job and sequence.

Hi, In development environment. My job design for passing passwords i have used the user defined environment variables(in both job and sequence). I pass this values to the job by sequence. It was working fine in development environment. But when i moved my code and changed the database user id &...