DSXchange

battaliou

Don't worry about it, your loads are working fine, the timestamp on the log entry for your default config file is a little misleading as the message is generated (flushed) at the same time as the job completes. Test it with 1000 rows and you will see what I mean. As a matter of interest can you post...

battaliou

I got the same error this morning. I was running 8 way multi-process, and all 8 came up with the warning as the last event in the log file. The data loaded ok, but my sequence failed as it did not get a "Executed OK" return. DS 8.1.0.0 no patches on SunOS 5.10. Scratch and Swap space fine....

battaliou

I am reading this as follows:
IF (Input_Lnk.Parent_code= Input_Link.child_code) THEN Input_Lnk.CHILD_SK ELSE 1

battaliou

This would appear to be the case. Insert into the job the APT_NO_SORT_INSERTION environment variable as "TRUE", and try again.

battaliou

I had the same issue "RC_DATA: Unable to generate a node map from fileset /ods_stage/TEMP/import_tmp_27228b937c2d4.fs." I simply deleted my sequential file stage and created a new one with the same settings, and now the job works. Thanks a lot James for the tip on $APT_IMPORT_PATTERN_USES_...

battaliou

In the Sequential file stage set your Source File to /dev/null and add a Filter with the following:

sort debug.txt

If you need to remove the header then:
sort debug.txt sed '$d'

battaliou

In the Sequential file stage set your Source File to /dev/null and add a Filter with the following:

sort debug.txt

If you need to remove the header then:
sort debug.txt sed '$d'

battaliou

A Server job will allow you to create a type 1 hashed file which would have the properties you require.

battaliou

You could use PERL, as this is probably available on your DS server.

Code: Select all

use strict;
use Digest::MD5  qw(md5_hex);
my $md5_data = "martin";
my $md5_hash = md5_hex( $md5_data );
print "$md5_hash\n";

battaliou

Include a pwd in your script to prove you are in the right directory when you run script from DS.

battaliou

Is your remove duplicate key the same as your join key?

battaliou

If you use venkateshrupineni solution then you can have two output's from your transformer into a funnel with a contraint on the 2nd output based on whether sv4<>''

battaliou

Did you fix this error? We had the same problem using decimals, as our TD supports a maximum of decimal(18) so when we had to populate a 38,2 we simply defined it as an 18,2 in DS.

battaliou

Take a look at the UNIX tr -s '\n\' ',' command.

battaliou

We are currently specifying this under DB options in the TD EE stage: user=#TRG_DB_USERID#,password='#TRG_DB_PASS#',SessionsPerPlayer=1,RequestedSessions=5,WORKDB=#TRG_DB_NAME#

Search found 153 matches