Skip to Content
0

Insert data into Lookup tables-SMART DATA INTEGRATION

Jun 20, 2017 at 11:19 PM

34

avatar image

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.

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
0

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

Share
10 |10000 characters needed characters left characters exceeded