Archive for March, 2016

Ex:- REG_REPLACE(Column, ‘\s+’, ‘ ’)

Like Function in Informatica:-

What is the equivalent expression for

case when CNTRY_NM like ‘%IND%’ the ‘India’ when CNTRY_NM like ‘%USA%’ then ‘USA’ end as CNTRY_NM

IIF(REG_MATCH(UPPER(CNTRY_NM),’.*IND.*’)=1,’India’,
IIF(REG_MATCH(UPPER(CNTRY_NM),’.*USA.*’)=1,’USA’,CNTRY_NM))

Note:- Make sure to use UPPER case on both side’s