DSXchange

If one of the variables are null, the whole string will evaluate to null: i.e.

Firstname: ' ' : Lastname

If Firstname = 'Rob'
Lastname - 'Wierdsma'
result will be 'Rob Wierdsma'

If Firstname = null
Lastname = 'smith'
result will be null.

Switching back to circular before the next run will quickly determine whether the new logging method is the culprit. Would this be difficult for the DBA to do? Part of the converstion with your DBA should be a suggestion that these changes be made in a dev environment first to determine the effect. ...

I'm thinking of going to the one here in Toronto tomorrow, where we have about 3 feet of snow, no green in sight. Supposed to get another 4-6 inches in the next day!

Getting the same errors.

Admin folks claim the server is busy!

Any insights? I'm running version 7.5x2 on Windows, which probably explains a lot.

Rob

Have you talked to IBM support? I have a dim memory of getting a patch for this issue, however, that was in Windows. Couldn't find the emails from the day.

Rob

We tried a number of different options in parallel, but none could give us an acceptable result.

In the end, we created a sequetial process to generate our surrogate keys.

Rob

What kind of load are you doing, MLoad or TPump? Is there anything in the TeraData utility report file that would shed light?

Rob

srimitta wrote:Thanks Ray I got it working

In output derivation
(NextSurrogateKey() + @PARTITIONNUM) / @NUMPARTITIONS

Yikes! What happens when the DS admin guys decide to change the number of partitions in production?

Rob

Having just delivered an app using TPump as the load utility, I can assure you that TPump WILL NOT be the fastest solution. TPump's purpose is essentially to allow trickle feeds. We used TPump for our lower volume tables (to satisfy the pointy haired boss's requirement for 'cool') and used MLoad for...

Try dumping field out to a sequential file. There you will see what the source is actually sending you, rather than what it's data access tool is displaying. If it is still in scientific notation (i.e. 1.23 e04) when dumped out, then you will need to convert.

Rob

Further to this thread.... We are now approaching the end of our testing phase and have needed to revisit the values for APT's mentioned above, so I'd like to document our findings. To briefly summarize, we have a file that we read in as a single wide column, splitting into component columns later i...

Hopefully someone will come up with an explaination one of these days.

In the mean time, the work around above seems to be working.

Rob

DSguru2B wrote:Is the stage variable nullable?

Can't set nullability in stage variables.

Rob

Just observed some bizzare behaviour. Performed logic similar to below in a stage variable: If InputLink.Var1 [1,1] = ' ' then SetNull() else If Count(InputLink.Var1 , '-') = 1 then SetNull() else InputLink.Var1 This resulted in the value from the previous row to be carried forward to the next row. ...

Hi Ray,

Got

main_program: Error parsing modify adapter: Error in binding: Encountered more than one 'handle_null' or 'make_null'
Expected destination field selector, got: ")";

on that attempt.

I think I'm going to use the transformer. No more time to play!

Rob