Skip to Content

how to put data from template table into already created target table ?.

Hii Bods experts, my doubt is regarding template table. My target db is sybase but empty table is created there already with required columns. Now I want to push my data from template table of my job in to that sybase table. I have already imported sybase table into designer. Now How should merge both template and target tables. Kindly reply asap. Now I want to push my data from template table of my job in to that sybase table. How should I do this ? Kindly reply asap.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 14, 2017 at 11:25 AM

    Hi Vibhor Gautam

    create a new dataflow and take template table as source and sybase table as target and execute. and in the main dataflow change your target from template table to sybase table.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vibhor,

      You can create new column in SCHEMA_OUT of Query transform and in the mapping tab you can write null. so that column will be filled with null.

      and for your condition

      eg: 1st condition is If RET_TYPE_ID=3 --> original

      else --> revised.

      Write below function in mapping tab of that column

      decode(RET_TYPE_ID=3,'original','revised'); ---- this works like if RET_TYPE_ID=3 then original else revised.

  • Sep 14, 2017 at 10:09 AM

    Hi Gautam,

    I think you should use your template table as a source table to load the data into target table..

    Thanks..

    Add comment
    10|10000 characters needed characters exceeded