Subramanian G

Tuesday, 19 July 2022

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"

Thursday, 2 December 2021

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")

Sunday, 19 September 2021

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;

Thursday, 26 August 2021

Windows Script to return current path

cd - To use in the command line

%cd% - To use in the scripts

Java Script - Replace forward slash with backward slash

str = get_instal_path_org;

res = str.replace(/\//g, "\\");;

Monday, 23 August 2021

AWS - Useful commands

LINUX Command to connect AWS using KEYS,

export AWS_ACCESS_KEY_ID=AKIAAAAUQG7QC2O4KS6NKGSM;

export AWS_SECRET_ACCESS_KEY=I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS;

aws s3 ls s3://kgsm/active/

s3://kgsm/raw

s3://kgsm/active

WINDOWS Command to connect AWS using KEYS,

setx AWS_ACCESS_KEY_ID AKIAV7UQG7Q7C2O4KS6NKGSM

setx AWS_SECRET_ACCESS_KEY I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS

setx AWS_DEFAULT_REGION us-east-1