Search found 4 matches

by rajalaa
Fri Jul 13, 2018 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Big integrate - joins
Replies: 1
Views: 1798

Big integrate - joins

Hello, I have datastage job which reads data from BDFS stage. The underlying HQL is currently reading data from single table (Hive Hql). All the other lookup / joins are done in Datastage job. What would be the advantage if I perform the joins with multiple tables in Hive hql and have the data read ...
by rajalaa
Fri Jul 13, 2018 1:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Edit / Combine DSX with same target table?
Replies: 9
Views: 6605

chulett wrote:So... do you have a resolution here?
We are still combining the jobs manually, any further suggestions would help
by rajalaa
Tue Jul 03, 2018 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Edit / Combine DSX with same target table?
Replies: 9
Views: 6605

Thanks for the replies. We did rule out RCP since the column derivations and lookup tables/columns for the columns are different. Also we are using BDFS stage and want to reduce the number of read/write across multiple jobs. Hence, we want to develop a single job with all the column calculation in t...
by rajalaa
Wed Jun 27, 2018 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Edit / Combine DSX with same target table?
Replies: 9
Views: 6605

Edit / Combine DSX with same target table?

Hi, I have multiple Datastage jobs that need to be created for loading into the same target table, basically, due to parallel development requirement to save time. So, I would have around 40 column derivations done by developer1 in one Datastage job and another developer would create second Datastag...