Search found 524 matches

by stuartjvnorton
Wed Aug 20, 2014 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To search for occurence of more than one character in string
Replies: 3
Views: 2076

Google "password strength checker algorithm" and see what you come up with.
You probably won't find your homework already complete, but you should at least get some ideas to proceed.
by stuartjvnorton
Wed Aug 20, 2014 6:15 pm
Forum: General
Topic: Display Files as date wise like aug 18th,19th,20th data file
Replies: 10
Views: 3928

Re: Display Files as date wise like aug 18th,19th,20th data

kiranchandra wrote:Display Files as date wise like aug 18th,19th,20th data files by using UNIX command
No. Don't feel like it.
by stuartjvnorton
Tue Aug 19, 2014 5:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replacement for function DSGetLinkinfo in Parallel
Replies: 2
Views: 2083

Are you saying you already use it, or would like to? If you already use it, check your args going to 9.1. IIRC the enum to request the row count has changed. There is also the potential for getting incomplete counts back. I've only seen it at one site under full batch load, but it's not 100% guarant...
by stuartjvnorton
Wed Aug 06, 2014 11:40 pm
Forum: General
Topic: ETL process from source to staging
Replies: 3
Views: 1566

Write your own solution architecture! ;-)
by stuartjvnorton
Wed Aug 06, 2014 8:25 am
Forum: Infosphere Master Data Management
Topic: IBM Initiate
Replies: 2
Views: 20004

They have let you use QS matching for a long time: long before they bought Initiate. Haven't used it a whole lot, but I found the stan part of the process a bit hard to use: you could often select invalid combinations that you wouldn't be able to run, and very little insight into what each method di...
by stuartjvnorton
Tue Aug 05, 2014 6:40 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Business rules
Replies: 15
Views: 19034

A token is any group of characters that are bundled together after the list of separator characters have been applied to the text. QS stan works by first separating the text into tokens and then stripping the unwanted characters, by applying the SepList and StripList. When you read text, we use spac...
by stuartjvnorton
Sat Aug 02, 2014 9:51 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Business rules
Replies: 15
Views: 19034

The ones you have put here are for an empty field, then 1, 2, and 3 numbers. The million-odd distinct values is making a bit more sense. Do you get a lot of terms in the token report? Might be worth trying couple of times to get just the unknown words, then the numbers too, etc. The ^ is a Pattern A...
by stuartjvnorton
Tue Jul 22, 2014 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scenario: Identify duplicated in a column
Replies: 6
Views: 5039

Transformer: split using Field and put into alphabetical order, eg: IND,AUS -> AUS,IND
Sort with key change
Filter by key change= 1
by stuartjvnorton
Thu Jul 17, 2014 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage - Flash Player
Replies: 9
Views: 8036

No, I've seen this.

From memory, the XML Stage and possibly Data Rules Stage editors inside the stage dialogs don't display properly (and aren't usable) without it.

Part of my 9.1 SOP.
by stuartjvnorton
Wed Jul 09, 2014 5:58 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Business rules
Replies: 15
Views: 19034

LOL I'm still back on how this "colour" field has over 1 million distinct values... You also do not want to create a frequency by frequency to display the whole list. If it even comes back after the day and a half it would take to put that sucker together, no one will ever look at a 30k pa...
by stuartjvnorton
Tue Jul 08, 2014 5:40 pm
Forum: General
Topic: What's the Coolest Feature of DataStage?
Replies: 18
Views: 9478

asorrell wrote:I mean its obvious the product has way too many cool features, IBM had to skip an entire release number just to illustrate how much new functionality was being added! :-P
That's one interpretation. ;-)
by stuartjvnorton
Mon Jul 07, 2014 5:47 pm
Forum: General
Topic: What's the Coolest Feature of DataStage?
Replies: 18
Views: 9478

For me, it's the Monitor, Related Logs, and API.
by stuartjvnorton
Mon Jun 30, 2014 5:51 pm
Forum: IBM QualityStage
Topic: Name Cleansing PTY LTD
Replies: 5
Views: 6004

I'd look go with Robert's "also" suggestion. I don't like the way it puts PTY at the end of PrimaryName_AUAME and LTD in NameSuffix_AUNAME. I like to move them both to NameSuffix_AUNAME. The concatenation at the end doesn't change, but can help marginally with matching. You could do that e...
by stuartjvnorton
Thu Jun 26, 2014 5:46 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to retrieve data from IA DB and load it into Cognos DB
Replies: 2
Views: 6538

http://dsxchange.com/viewtopic.php?t=15 ... c287e4b1c4

Also goes through how to automate the execution as well, if you're keen.
IAAdmin options are in chapter 16 or 17 of the IA Users Guide.
by stuartjvnorton
Mon Jun 23, 2014 6:21 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Business rules
Replies: 15
Views: 19034

The job of IA is to analyse data, not modify it. Since you've already done the column analysis, you could either create a mapping table if the list is fairly static. You could use QualityStage to create a ruleset and do some standardisation, but if you're just looking at standardising a finite list ...