Insert data into Lookup tables-SMART DATA INTEGRATION

Jun 20, 2017 at 11:19 PM|40 Views

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.

Related questions

1 Answer

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?