Creating a Multi Valued Attribute in Talend Open Studio

I think this blog post is going to be more relevant as NoSQL databases catch on where data is packed in columns.  The topic is how to create a multi-valued attribute -- a comma-separated list of values -- from a bunch of rows.

Parsing a String using Talend Open Studio's tExtractRegexFields Component

A reader asked how to extract the bond type "CD" from the following input string: "CD Corporation du 20/12/2010 4.5% à 26 semaines".  Although it's easy to grab the first two characters in a tMap using a substring function, there is an off-the-shelf component tExtractRegexFields that can handle varying lengths.

SysML Block Properties in Sparx Systems EA 10

SysML 1.3 defines 4 types of properties that can be used by blocks: part, value, reference, and constraints.  Ports are handled as a special case.  This post demonstrates how part and reference properties are represented in Sparx Systems EA 10.

Revised SysML BDD and IBD of Bass Guitar Effects

Thanks to some great contributions from Stephan Roth, I've revised the SysML BDD and IBD I posted in two previous posts.  All diagrams were created using Sparx Systems EA 10.  The new BDD version uses aggregation and EA role names are used to ease the transition into the IBD.  The IBD features reference properties (because of the aggregation).

A SysML IBD of Bass Guitar Effects

Based on some feedback from a previous post, I created a SysML Internal Block Diagram to show the power connections between the various parts of my bass guitar effects setup.