Skip to main content Skip to complementary content

Creating the Job

Before you begin

  • A new Job has been created and the context variables SourceTableS with the value STUDENT, SourceTableT with the value TEACHER, and TargetTable with the value FULLINFO have been added to the Job. For more information about how to use context variables, see the related documentation about using contexts and variables.

  • The source table STUDENT with three columns, SID and TID of NUMBER(38,0) type and SNAME of VARCHAR(50) type, has been created in Snowflake, and the following data has been written into the table.

    #SID;SNAME;TID
    11;Alex;22
    12;Mark;23
    13;Stephane;21
    14;Cedric;22
    15;Bill;21
    16;Jack;23
    17;John;22
    18;Andrew;23
    
  • The source table TEACHER with three columns, TID of NUMBER(38,0) type and TNAME and TPHONE of VARCHAR(50) type, has been created in Snowflake, and the following data has been written into the table.

    #TID;TNAME;TPHONE
    21;Peter;+86 15812343456
    22;Michael;+86 13178964532
    23;Candice;+86 13923187456
    

Procedure

  1. Add a tSnowflakeConnection component, a tSnowflakeClose component, two tELTInput components, a tELTMap component, and a tELTOutput component to your Job.
  2. On the Basic setting view of the first tELTInput component, enter the name of the first source table in the Default Table Name field. In this example, it is the context variable context.SourceTableS.
  3. Repeat step 2 to set the value of the default table name for the second tELTInput component and the tELTOutput component to context.SourceTableT and context.TargetTable respectively.
  4. Link the first tELTInput component to the tELTMap component using the Link > context.SourceTableS (Table) connection.
  5. Link the second tELTInput component to the tELTMap component using the Link > context.SourceTableT (Table) connection.
  6. Link the tELTMap component to the tELTOutput component using the Link > *New Output* (Table) connection. The link will be renamed automatically to context.TargetTable (Table).
  7. Link the tSnowflakeConnection component to the tELTMap component using a Trigger > On Subjob Ok connection.
  8. Link the tELTMap component to the tSnowflakeClose component.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!