DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 11 matches
Author Message
Resolved
 Topic: set default value on look up failure
perspicax

Replies: 4
Views: 154

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 18, 2018 12:41 pm   Subject: set default value on look up failure
It works! I was using isnull vs ISNULL to handle and I think it is case sensitive.

In the hash file look up there is a function called NOTFOUND. Is this not relevant in parallel jobs?

Thanks!
Resolved
 Topic: set default value on look up failure
perspicax

Replies: 4
Views: 154

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 3:30 pm   Subject: set default value on look up failure
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have set the lookup stage conditions to 'continue' on lookup failure. These lookups are surrogate key lookup. It's defaulting to 0 for these values. Is there a way to default to a different value, l ...
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 137

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 1:20 pm   Subject: Convert space to null
I used setnull() and it works. I think @NULL works only in server jobs.

Maybe this is for another topic, I only see 5-6 system variables in parallel job while using transformer. Is there any settin ...
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 137

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 12:34 pm   Subject: Convert space to null
Also it says @NULL not defined. I do not see @NULL defined under system variable
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 137

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 12:33 pm   Subject: Convert space to null
The if expression is not evaluating to true. It is not inserting even "NULL" instead it's inserting 0
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 137

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 12:10 pm   Subject: Convert space to null
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Is there a way to convert blank space to NULL. We have fields from the source application that can have ' ' representing NULL. We would like to load NULL in DW.

IF (LEN(TRIM(lnk_from_src.FIELD_XYZ, ...
 Topic: Lookup recommendation
perspicax

Replies: 1
Views: 402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 12, 2018 3:39 pm   Subject: Lookup recommendation
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
New to DS parallel edition. I am trying to build a DS job for a fact table which has references to 35 dimensions (via Surrogate key).

What is the best way to populate the Surrogate keys. I do not w ...
 Topic: Problem joining four tables
perspicax

Replies: 7
Views: 984

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 11, 2017 3:37 pm   Subject: Problem joining four tables
My scenario doesn't work then? The join key column is different for different set of tables. For A & B it is ID1 which is identically named and have same data types, similarly for B & C it is ...
 Topic: Problem joining four tables
perspicax

Replies: 7
Views: 984

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 08, 2017 4:33 pm   Subject: Problem joining four tables
Yes you are correct about the join.

Yes, I was able to make it work with 3 join stages. So we cannot use one join stage at all for this scenario?

When you say, input needs to be partitioned and ...
 Topic: Problem joining four tables
perspicax

Replies: 7
Views: 984

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 5:37 pm   Subject: Problem joining four tables
Two tables are from Oracle, 1 table from SQL server and one is a file. So these are disparate sources. I am trying to achieve using Join operator/stage what the above sql would do
 Topic: Problem joining four tables
perspicax

Replies: 7
Views: 984

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 4:00 pm   Subject: Problem joining four tables
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
New to DS. I am trying join 4 tables using the Join stage. The table structure are as follows

Tab_A
ID1 -->Key
xyz

TAB_B
ID1 --> Common Key for B & A
ID2 --> Common Key fo ...
 

 Jump to:   



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