DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 527 matches
Author Message
 Topic: How to calculate match stage scores
stuartjvnorton

Replies: 5
Views: 2253

PostForum: IBM QualityStage   Posted: Mon Jan 06, 2020 4:09 pm   Subject: How to calculate match stage scores
Firstly, I had to laugh at the idea of IBM giving you the source code. There's no way they're going to give you their secret sauce. Just saying.


On the question at hand though, it's been a while ...
 Topic: IA-Column Analysis-Incorrect inferred results for a column
stuartjvnorton

Replies: 4
Views: 2145

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Sat Dec 28, 2019 1:41 pm   Subject: IA-Column Analysis-Incorrect inferred results for a column
Out of curiosity, what is the maximum length of the actual data in your field?
 Topic: Quick fix in Prod - Before / After statements
stuartjvnorton

Replies: 9
Views: 1691

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 29, 2019 1:15 am   Subject: Quick fix in Prod - Before / After statements
Yeah, that argument is a slippery slope to nowhere good.

The business don't care about proper IT dev practices, that's not their job. Expect them to push for the most expedient thing they can get a ...
 Topic: Quick fix in Prod - Before / After statements
stuartjvnorton

Replies: 9
Views: 1691

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 24, 2019 9:22 pm   Subject: Quick fix in Prod - Before / After statements
https://i.imgflip.com/3bl4wu.jpg
 Topic: Automated Code review/check
stuartjvnorton

Replies: 11
Views: 16329

PostForum: Enhancement Wish List   Posted: Thu May 16, 2019 7:37 am   Subject: Automated Code review/check
MettleCI offers what it calls Compliance checking as part of its CICD processes, and it can also be run standalone through the Workbench.
It has a number of pre-canned rules to check things like nami ...
 Topic: Code Review tool for DataStage
stuartjvnorton

Replies: 3
Views: 1239

PostForum: General   Posted: Thu May 16, 2019 7:36 am   Subject: Code Review tool for DataStage
MettleCI offers what it calls Compliance checking as part of its CICD processes, and it can also be run standalone through the Workbench.
It has a number of pre-canned rules to check things like nami ...
Resolved
 Topic: DSODB - Is there a DSODB data dictionary?
stuartjvnorton

Replies: 6
Views: 1339

PostForum: General   Posted: Tue May 07, 2019 7:53 am   Subject: DSODB - Is there a DSODB data dictionary?
Hi Paul,

I checked those links, and the 1st and 3rd have a link to the pdf at the bottom of the page.
The 2nd was a pdf.

Or are you saying the old pdf's were different and you want those ones?
 Topic: Column Analysis Sample - recommendations, best practices
stuartjvnorton

Replies: 2
Views: 1095

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Apr 09, 2019 8:06 am   Subject: Column Analysis Sample - recommendations, best practices
Sampling can be a tricky one.

I have seen large tables profiled in the past and set a pre-defined sample size, eg: 1M records. Need to be careful here.
In one example, review showed a particular f ...
 Topic: Drill Down User Role
stuartjvnorton

Replies: 4
Views: 1788

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Apr 03, 2019 3:17 pm   Subject: Drill Down User Role
Dumb question I'm sure, but you selected "Enable drill down security" in the Details tab of the Project Properties?

Drill Down Role is project-specific and IIRC the role is ignored (ie granted by d ...
 Topic: Automated deployments using Team Foundation Server?
stuartjvnorton

Replies: 4
Views: 1199

PostForum: General   Posted: Tue Dec 04, 2018 8:49 pm   Subject: Automated deployments using Team Foundation Server?
Might be worth checking this out:

https://www.mettleci.com/
Workaround Reported
 Topic: Cannot profile columns with a "/" in the name
stuartjvnorton

Replies: 7
Views: 3173

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Apr 26, 2018 8:24 pm   Subject: Cannot profile columns with a "/" in the name
Had to go with the views, unfortunately.
HANA is not on Information Server's list of ODBC supported databases.
Workaround Reported
 Topic: Cannot profile columns with a "/" in the name
stuartjvnorton

Replies: 7
Views: 3173

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Apr 17, 2018 12:49 am   Subject: Cannot profile columns with a "/" in the name
Hi Craig,

Yeah, we've resigned ourselves to that fact too.

We were hoping to avoid that, as:
- we don't own the database so only have read-only access to it.
- the issue affects around 14k ...
Workaround Reported
 Topic: Cannot profile columns with a "/" in the name
stuartjvnorton

Replies: 7
Views: 3173

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Sun Apr 15, 2018 10:26 pm   Subject: Cannot profile columns with a "/" in the name
Hey Ray,

I raised a PMR but they just came back with "SAP HANA is not supported".
This isn't just a HANA problem. I've seen this sort of thing in SQL Server in the past, and SQL Server is obviousl ...
Workaround Reported
 Topic: Cannot profile columns with a "/" in the name
stuartjvnorton

Replies: 7
Views: 3173

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Apr 12, 2018 6:07 pm   Subject: Cannot profile columns with a "/" in the name
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I am attempting to run column analysis on SAP HANA.
We have:
- connected to it via ODBC through the HANA driver
- and have successfully imported and shared metadata through IMAM
- created an IA pr ...
 Topic: IA Custom DataClass not returning example data
stuartjvnorton

Replies: 5
Views: 2824

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Nov 29, 2017 5:42 pm   Subject: IA Custom DataClass not returning example data
Hi guys,

Yes, I've tested the regex and it works.

I think this one is on me. Someone had made a change to the settings to reuse the IADB tables, and the generate FD tables is mutually exclusive ...
 

 Jump to:   



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