Skip to Content
avatar image
Former Member

How to Update Flag in Source Tables

Hi

Populating data from two tables with join condition and loading into the one target table.

Post loading data into the target table, I need to update one column in each source table for the same data. i.e. Need to update the FLAG column for matched records between source and target tables.

No Key columns and Date colums present

Thanks & Regards

Suresh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 06, 2015 at 12:49 PM

    Hi Suresh,

    there is no option to change values in the source table. Therefor you have to create a second dataflow and use the source tables as target tables. In your case, you should connect the first dataflow with the second to be sure, that the dataflows will be finish in the correct order.

    Regards

    Severin

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 05:48 PM

    Hi Suresh,

    You can either achieve this using a second dataflow as mentioned in this thread or using a script connected to the first dataflow where you can use an update statement to update the source tables based on the data loaded into the target table.

    kind regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Raghunathan Balasubramanian

      The options are indeed various and it depends on the individual circumstance to decide on what to choose from.

      Suresh

  • avatar image
    Former Member
    Jan 02, 2015 at 05:38 PM

    You need to use the same columns that you used for joining the source tables

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 15, 2015 at 01:59 PM

    Hi All,

    I am very happy to receive such good response and I implemented the functionality by creating the two datafolows. Pending need to check the data performance.

    Thanks & Regards

    Suresh.

    Add comment
    10|10000 characters needed characters exceeded