Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
CREATE TABLE ANALYTICS.BQMS_EXPLODED_SAMPLES
  (
  KEY VARCHAR2 (100),
  SUMMARY VARCHAR2 (100),
  STATUS VARCHAR2 (50),
  REPORTER VARCHAR2 (60),
  PRODUCT_AND_PROCESS VARCHAR2 (100),
  SAMPLE_ID VARCHAR2 (50),
  UPDATED DATE
 )
/

CREATE INDEX ANALYTICS.BQMS_EXPLODED_SAMPLES_IDX1 ON BQMS_EXPLODED_SAMPLES(KEY ASC) 
/

GRANT ALL ON BQMS_EXPLODED_SAMPLES TO analyticsetl
/

Step 3: Register a new JqlTask in

...

“/home/unix/analytics/TigerETL3/jqlTasks.conf” file

...

Step 4: Test your ETL in manual mode

...