Identifying CASE transforms

dataservices metadata reports
1

Hi,

Is there any easy way of identifying all the dataflows in a repository using one or more CASE statements. We are using Data Services 3.1, but don’t have Metadata Manager.

Thanks
Simon

simonkirk (BOB member since 2006-10-10)

2

export your dfs to a dat file and proceed with a textual search. Later on you can automate it processing it with SED (which is available on windows too. Check it out at: http://gnuwin32.sourceforge.net/packages/sed.htm) along with the proper regex.

CLS69 :it: (BOB member since 2009-06-11)