DSXchange

Source 1 is connector stage and stream. Source 2 is Lookup_File and reference. The stream needs to do a range lookup to the Lookup_File, with the lookup stage. But I can't perform the range lookup with that combination. It does work with 2 connector stages, but I would like to use the Lookup_file be...

I was trying to get the 12mio rows with a Lookup_file. But I can't use it for a range lookup when I'm joining with a Connector stage.
I cannot get the right input link on stream so I can define the range.
Any idea's?

Columns: 24
Bytes Used: 2.199 GB
Bytes Allocated: 2.227 GB
Skew: 0.010000
Row Count: 18,023,892
% Organized: -
Distribution Keys:
Distribution Key Count:

I can't mail to the webmaster, I get the following notification. ----- The following addresses had permanent fatal errors ----- XXXXX@gmail.com (reason: 550-5.7.1 [66.34.129.46 12] Our system has detected that this message is) (expanded from: <webmaster@dsxchange.com>) XXXXX@gmail.com (reason: 550-5...

Hi all, I would like to left outer join data from a 12million+ rows table onto my stream data, with a DATE from the stream into START_DATE and END_DATE in the 12m+ table. select A.*, B.* from A, B left outer join B on A.key = B.key where A.DATE >= B.START_DATE and A.DATE < B.END_DATE In a Join and M...

Yes, thanks!

Thanks Shane!

It is in varchar unicode, both input and output.

Hi Shane, thanks for the fast reply.

I manually inserted the records from the SQL overwrite into the DWH and that works fine, no adjustment of characters.

The column data types are OK in DS.

It looks like the DS proces is transforming the characters.

Hi, my name is Dirk and I am new here. Hopefully we can help each other out. My problem: Input is house numbers like '10', '11b', '12 - c', '12/2' and I would like the output split in two output lines like this: '10' = '10' and NULL '11b' = '11' and 'b' '12 - c' = '12' and '- c' '12/2' = '12' and '/...