Archives of the TeradataForum

Message Posted: Thu, 30 Sep 2010 @ 09:25:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Thank for your replies guys.

It is our requirement to run the ETL jobs within 1 minute interval, every hour.

Below is the actual table and the update statment.

     CREATE MULTISET TABLE target_table ,FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           col_1 VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           col_2 VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           col_3 INTEGER NOT NULL,
           col_4 INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY
                (START WITH 1
                 INCREMENT BY 1
                 MINVALUE -2147483647
                 MAXVALUE 2147483647
                 NO CYCLE),
           INSERT_ID INTEGER,
           UPDATE_ID INTEGER)
     UNIQUE PRIMARY INDEX ( col_4 );

     Update target_table
     Set update_id = ORCHESTRATE.update_id
     Where ORCHESTRATE.col_1 = sk_event_id_lookup.col_1 AND ORCHESTRATE.col_2=
     sk_event_id_lookup.col_2 AND ORCHESTRATE.col_3 = sk_event_id_lookup.col_3

We cannot do separate table for each country, because everytime we need to add a new country we need to create a seperate table. This is in production, won't able to change the job.

Any suggestion would be appreciated.

Thank you,

Naveen

	<Prev	Next>		<<First	<Prev	Next>	Last>>