DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 12 matches
Author Message
 Topic: How to join data with a BETWEEN function
dveltman1

Replies: 8
Views: 3401

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 17, 2015 8:22 am   Subject: How to join data with a BETWEEN function
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 loo ...
 Topic: How to join data with a BETWEEN function
dveltman1

Replies: 8
Views: 3401

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 16, 2015 3:52 am   Subject: How to join data with a BETWEEN function
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 ...
 Topic: How to join data with a BETWEEN function
dveltman1

Replies: 8
Views: 3401

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 14, 2015 2:14 am   Subject: How to join data with a BETWEEN function
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:
 Topic: webmaster email rejected
dveltman1

Replies: 1
Views: 5246

PostForum: Site/Forum   Posted: Tue Jul 14, 2015 12:43 am   Subject: webmaster email rejected
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 ...
 Topic: How to join data with a BETWEEN function
dveltman1

Replies: 8
Views: 3401

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 14, 2015 12:29 am   Subject: How to join data with a BETWEEN function
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Parallel job problem with NLS/BOM
dveltman1

Replies: 6
Views: 2731

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 08, 2015 3:00 am   Subject: Parallel job problem with NLS/BOM
I changed the input and output column in DB and DS to nvarchar and now it works fine.

In the Netezza ODBC "odbcinst.ini" configuration file, the following options are defined :

UnicodeTranslati ...
Resolved
 Topic: How to get string from VarChar from first non-numeric value
dveltman1

Replies: 7
Views: 3131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 07, 2015 3:28 am   Subject: How to get string from VarChar from first non-numeric value
Yes, thanks!
Resolved
 Topic: How to get string from VarChar from first non-numeric value
dveltman1

Replies: 7
Views: 3131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 06, 2015 1:27 am   Subject: How to get string from VarChar from first non-numeric value
Thanks Shane!
 Topic: Parallel job problem with NLS/BOM
dveltman1

Replies: 6
Views: 2731

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 03, 2015 7:24 am   Subject: Parallel job problem with NLS/BOM
It is in varchar unicode, both input and output.
 Topic: Parallel job problem with NLS/BOM
dveltman1

Replies: 6
Views: 2731

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 03, 2015 1:07 am   Subject: Parallel job problem with NLS/BOM
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.

...
 Topic: Parallel job problem with NLS/BOM
dveltman1

Replies: 6
Views: 2731

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 02, 2015 6:39 am   Subject: Parallel job problem with NLS/BOM
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
We are on Netezza loading data from staging to DWH.
The NLS on the DB server is UTF-8 and the DS project has UTF-8 set in Administration. The parallel job takes the Project NLS by default.

My job ...
Resolved
 Topic: How to get string from VarChar from first non-numeric value
dveltman1

Replies: 7
Views: 3131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 02, 2015 6:27 am   Subject: How to get string from VarChar from first non-numeric value
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 outpu ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours