Drop Table - If foreign key exists

 DROP TABLE if exists abc cascade;

JAVA SCRIPT - TO GET THE CHARACTER POSITION & SLICE(STRING CUT)

var out_filename = short_filename.slice(0, short_filename.indexOf("."))

CRON Schedule

0 5 * * * /home/pentaho/pentaho-pdi/data-integration/pan.sh -file="/home/pentaho/test/tr_test.ktr" –level: Basic –logfile="/home/pentaho/test/test.log"

List file names in a directory by file explorer

• Go to the specific directory where files are stored.
• Select all files by CNTRL+A.
• Press Shift and Right click on files
• Select “copy as path” from right click menu
• Paste the result in file editor

VLOOKUP - Data Cleansing - MSExcel

 =IF(ISNA(VLOOKUP($B3,G$3:G$26,1,FALSE)), "Not Present", "Present")

=IF(ISNA(VLOOKUP($D3,B$3:B$27,1,FALSE)), "Not Used", "Used")

Create Sequence in tables

CREATE SEQUENCE public.seq_abcded_id

    INCREMENT 1

    START 1

    MINVALUE 1

    MAXVALUE 9223372036854775807

    CACHE 1;

ALTER SEQUENCE public.seq_abcded_id

    OWNER TO postgres;

CREATE TABLE public.abcde

(

    id integer NOT NULL DEFAULT nextval('seq_abcded_id'::regclass),

    name character varying(100),

    PRIMARY KEY (id)

)

WITH (

    OIDS = FALSE

);

ALTER TABLE public.abcde

    OWNER to postgres;

Windows Script to return current path

 cd - To use in the command line

%cd% - To use in the scripts