DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 5 matches
Author Message
 Topic: Lookup recommendation
perspicax

Replies: 1
Views: 153

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: 803

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: 803

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: 803

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: 803

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