Skip to Content

Insert data into Lookup tables-SMART DATA INTEGRATION

Jun 20, 2017 at 11:19 PM


avatar image
Former Member


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?


Urmil Kansara.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
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

10 |10000 characters needed characters left characters exceeded