DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 50 matches
Author Message
 Topic: Requesting advice on Data Lineage options
johnboy3

Replies: 4
Views: 1868

PostForum: General   Posted: Thu Jul 13, 2017 8:36 am   Subject: Requesting advice on Data Lineage options
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: DataStage, IIS and / or Oracle data lineage
OK guys, I'm confused but I know some of you can help me.

Management is considering software upgrades that may involve re-writing DataStage jobs somehow. I recently provided them with Oracle's deli ...
 Topic: Resetting Auto-Purge for existing jobs
johnboy3

Replies: 10
Views: 2848

PostForum: General   Posted: Tue Jun 06, 2017 1:46 pm   Subject: Resetting Auto-Purge for existing jobs
in the short run, you may get relief by selecting "Show Folders" on the VIEW drop-down menu.

If you are familiar with the folder structure of your project(s), and you don't NEED to see all jobs sim ...
 Topic: Premium membership
johnboy3

Replies: 2
Views: 4613

PostForum: Site/Forum   Posted: Tue Mar 14, 2017 6:57 am   Subject: This thread has phone number to sms, on page two
Find phone number to sms on page two:

http://www.dsxchange.com/viewtopic.php?t=156247&postdays=0&postorder=asc&start=15

john3
 Topic: Sort Memory in Infosphere
johnboy3

Replies: 3
Views: 1698

PostForum: General   Posted: Wed Jan 25, 2017 7:46 am   Subject: Sort Memory in Infosphere
Wow! Let me have my first cup of coffee before starting my cruel day. haha
john3
 Topic: Hierarchical Stage XML transformation aborts
johnboy3

Replies: 12
Views: 7851

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 04, 2017 1:35 pm   Subject: Hierarchical Stage XML transformation aborts
If you give it a primary key, does that make it no longer be a "heap?"
john3
 Topic: last import information of Datastage job
johnboy3

Replies: 13
Views: 4647

PostForum: General   Posted: Wed Oct 19, 2016 8:02 am   Subject: last import information of Datastage job
Would Job Lineage provide this?
john3
 Topic: last import information of Datastage job
johnboy3

Replies: 13
Views: 4647

PostForum: General   Posted: Mon Oct 17, 2016 8:19 am   Subject: last import information of Datastage job
Would you like to just check the Job's Log in DataStage Director? Depending on how you have logging configured, that may show the entire history of the running of that Job.

Did I misunderstand some ...
Resolved
 Topic: Running SQL statements in datastage
johnboy3

Replies: 7
Views: 4008

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 14, 2016 8:36 am   Subject: Running SQL statements in datastage
Oracle's SQL Developer lets you right-click and select TABLE and COPY to quickly copy one table to a new table. There is a check-box for if you want data.

I just tested and it seemed to be reasonab ...
 Topic: Need help concatenating rows
johnboy3

Replies: 8
Views: 2615

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 30, 2016 7:31 am   Subject: Need help concatenating rows
Curious problem.

More information please.
john3
Resolved
 Topic: Refreshing DS Project from PRD down to TST
johnboy3

Replies: 8
Views: 2699

PostForum: General   Posted: Tue Sep 27, 2016 7:26 am   Subject: Refreshing DS Project from PRD down to TST
Andy Sorrell,

Thank you, thank you, thank you! Your advice looks excellent. I do wonder about my ability. I'm thinking this resolves my general advice question. However please feel free to continue ...
Resolved
 Topic: Refreshing DS Project from PRD down to TST
johnboy3

Replies: 8
Views: 2699

PostForum: General   Posted: Tue Sep 27, 2016 7:14 am   Subject: Refreshing DS Project from PRD down to TST
Franklin,
Luckily we seem to have designs and executables for all Jobs in PRD. Thank you for your advice.
john3
Resolved
 Topic: Refreshing DS Project from PRD down to TST
johnboy3

Replies: 8
Views: 2699

PostForum: General   Posted: Tue Sep 27, 2016 7:10 am   Subject: Refreshing DS Project from PRD down to TST
Many thanks everyone. I am humbled and intimidated.

Lots of good information here. I hope we can do this.

Fingers crossed,
john3
Resolved
 Topic: Refreshing DS Project from PRD down to TST
johnboy3

Replies: 8
Views: 2699

PostForum: General   Posted: Fri Sep 23, 2016 8:38 am   Subject: Refreshing DS Project from PRD down to TST
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Guys,

I need advice. We had someone else (who is more or less gone now) set up our TEST environment, with the understanding that our DataStage Project would be copied down from PROD to TEST.

Thi ...
Resolved
 Topic: Charter Membership Renewal
johnboy3

Replies: 21
Views: 24448

PostForum: Site/Forum   Posted: Mon Sep 19, 2016 7:37 am   Subject: Charter Membership Renewal
This is worrisome. I paid for 2 years and I've got plenty of time left, but whenever I do have to re-subscribe I don't want to do without this valuable resource!

Can't somone look at this process a ...
Resolved
 Topic: Unable to access Project - Session Expired issue
johnboy3

Replies: 7
Views: 3507

PostForum: General   Posted: Fri Sep 16, 2016 7:30 am   Subject: Unable to access Project - Session Expired issue
Did you try logging in from someone else's workstation? It could be specific to that machine.

Also, when they uninstall you might want them to uninstall all DataStage software and manually delete a ...
 

 Jump to:   



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