Things learned other than Pentaho

28 Jan 2014

CREATE DATABASE LINK (Oracle)


Sample query
select A.column1 from TABLEA A where not exists (select 1 from TABLEA, schemaX.TABLEZ Z where A.Column1=Z.Column2)


JAVA SCRIPT

Example
var str = "Hyderabad";
var result=  str.substr(1,4) 
So result is yder

Format
str.substr(Index Number,# of characters from Index)

--
CHECK FOR NUMERIC DATA


replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789', '00000000000' ), '0', '' ) is  null  condition will identify the data (numeric data only) 


replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789', '00000000000' ), '0', '' ) is not null  condition will identify the data (contains non-numeric data) that require cleansing.  



Comments

Popular posts from this blog

Pentaho ETL

Copy files from one computer to other using ‘scp’ command