Wednesday, 27 July 2022

Drop Table - If foreign key exists

 DROP TABLE if exists abc cascade;

Tuesday, 19 July 2022

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"

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...