...
Code Block | ||
---|---|---|
| ||
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
...