Home Expression Samples Power Center Expression Samples
Friday, 11 November 2011 10:52

Power Center Expression Samples

Written by 
Rate this item
(1 Vote)

 

 The samples below show how to use expression variables to count rows and how to check if string follows required pattern.

 Variable usage example (expression local variables):

It shows how to write rows to two targets as follows: two rows to one target and two rows to second target and so on.  

 

 

How to check whether string follows given pattern (regular expression):

The pattern is defined in a given port, let's say first. Second port shows a string. It is required to check if the string follows pattern from the first port, where 9 means only number, X number or letter

 

  

 

This was prepared for PowerCenter version 9.0.0

Inside is attached source flat file, which must be loaded to default source folder.

It is required to use Repository Manager to import the examples.

Let me know ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it ) whether there is something wrong.  

 

Read 3974 times Last modified on Wednesday, 21 March 2012 07:56