DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 193 matches
Author Message
Workaround Reported
 Topic: Trying to extract row with certain criteria
mouthou

Replies: 2
Views: 33

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 22, 2019 12:20 pm   Subject: Trying to extract row with certain criteria
Transformer stage is an option for this scenario and it should work with your constraint. I suspect the format of the input values coming for 'STAT CODE' is not correctly compared.

- Can you can c ...
 Topic: Factors to decide the run mode of Oracle connector
mouthou

Replies: 5
Views: 221

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 10, 2019 2:54 pm   Subject: Re: Factors to decide the run mode of Oracle connector
It is understood that you are trying to do some performance testing and that too using Join stage in DataStage.

Is there any difficulty in joining the 2 queries using DB join itself? And what is th ...
 Topic: Run time column propogation
mouthou

Replies: 6
Views: 473

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 10, 2019 2:38 pm   Subject: Run time column propogation
I also don't think there the inbuilt stages have options to accept the entire IF-THEN-CLAUSE as dynamic parameter. As an alternate approach, you can use MODIFY/FILTER STAGE which allows the dynamic co ...
 Topic: Surrogate Key stage issue
mouthou

Replies: 3
Views: 374

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 11, 2019 11:41 pm   Subject: Re: Surrogate Key stage issue
Assuming that your migration included the surrogate key files to new Linux platform, couple of things you could check:

1. if the files have been moved by the deployment team properly (as these are ...
 Topic: Put quotes around fields in sequential file only with commas
mouthou

Replies: 2
Views: 224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 11, 2019 11:27 pm   Subject: Put quotes around fields in sequential file only with commas
Question/scenario makes the brain to wander a little bit! In future, putting some sample input and expected output will help.

Is this your clarification on when the quotes will be put by DataStage. ...
 Topic: Oracle connector - Deadlock issue
mouthou

Replies: 9
Views: 626

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 18, 2019 2:27 am   Subject: Oracle connector - Deadlock issue
yes you are logically correct as per the link ordering but I am thinking in the lines of duplicate rows getting into one particular link itself. We had such issues with duplicate data getting processe ...
 Topic: Oracle connector - Deadlock issue
mouthou

Replies: 9
Views: 626

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 14, 2019 1:41 am   Subject: Oracle connector - Deadlock issue
as the deadlock error comes out of Oracle, it is pretty obvious that there is same record going for more than one operation at the same time.

For debugging purpose, try removing the one link each ...
 Topic: Datastage Director Monitor not displaying row counts
mouthou

Replies: 2
Views: 609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2019 10:55 pm   Subject: Datastage Director Monitor not displaying row counts
As chulett pointed out, the bottomline is the "JobMon" app to be running on the server. If not, contact your datastage admin to restart the service completely and verify till you see something in "ps ...
Resolved
 Topic: Lineage Report
mouthou

Replies: 2
Views: 678

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2019 10:36 pm   Subject: Lineage Report
It talks about IGC console only and administration there. May be your user id don't have necessary privileges to see the Admin section.

Try login with some admin user to see if you get Administrati ...
 Topic: Need to get Object list from Package (.pkg) file
mouthou

Replies: 6
Views: 499

PostForum: General   Posted: Mon Feb 04, 2019 7:40 pm   Subject: Need to get Object list from Package (.pkg) file
What do you mean by DataStage package? Do you have list exported already. DataStage package means isx kind of packages here, so needing more clarity.

Again your other question needs clarity too. Wi ...
 Topic: Check if multiple rows returned from Lookup Stage
mouthou

Replies: 5
Views: 684

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jan 20, 2019 11:15 pm   Subject: Check if multiple rows returned from Lookup Stage
I think your colleagues are not entirely correct and working up entirely in Datastage is a selective scenario. Best practice is to push the operation to DB so the minimal preprocessing like yours happ ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 747

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 18, 2019 3:47 am   Subject: Runtime comparision of tables using TD connector stage?
I think runtime could be in any scenario, be it one time or incremental batch loads. I meant the runtime as to pass the something like tablename when the validation job runs.

This is a temporary v ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 747

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 16, 2019 9:43 pm   Subject: Runtime comparision of tables using TD connector stage?
Thanks for everyone's comments. To answer few questions from Ray and Chulett

- Yes I also expected a native solution to do within the DB but there isnt much known yet (It will be 2 different DB pro ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 747

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 16, 2019 3:09 am   Subject: Runtime comparision of tables using TD connector stage?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We have about 700-800 existing Teradata tables which required to be migrated to a different Teradata DB server and compare the new data set with the existing set as and when DataStage jobs ...
 Topic: identifying conductor node in default pool
mouthou

Replies: 10
Views: 1184

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jul 22, 2018 6:08 am   Subject: identifying conductor node in default pool
Thanks Ray. I thought to clarify the question with 2 samples of config files.

config1:

node1
{
fastname dsserver
pools ""
..........
...
 

 Jump to:   



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