Skip to Content
avatar image
Former Member

Insert data into Lookup tables-SMART DATA INTEGRATION

Hi,

I have requirement that when I use flowgraph(Smart Data Integration) to do some filtering and cleansing of records at that time if data is not present in lookup table then I want to add the data into lookup table.

Can you please help?

Thanks,

Urmil Kansara.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 22, 2017 at 12:16 AM

    Hello Urmil,

    So what you want to do sounds for me more like a TableComparison Use-Case, where you want to compare the two tables and filter out the records present in the input and not in the compared table. Those records could then be inserted into a DataSink that is actually pointing to the compared table. Does that make sense?

    Kind regards,
    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded