Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

What is the difference between Lookup and table comparison transformation

Hi Experts ,

Can you please explain

What is the difference between Lookup and Table comparison transformation  on SAP BODS


Pavan M



Hi Pavan,

The lookup() is a function call used in data services which retrieves a value in a table or file based on the values in a different source table or file whereas a Table comparison transform is a transform which compares two data sets and produces the difference between them as a data set with rows flagged as INSERT, UPDATE, or DELETE i.e in simple terms you are comparing Source and Target table and asking the transform what exactly has changed(upsert).

You can use the lookup inside the query transform, mappings of columns.

Theoretically a lookup is similar to a SQL function call. A function takes one or multiple values as input and returns one (or multiple) value as output.

Lookups in SAP BODI/DS | A small notes. . .

Table comparison is used for detecting Target based CDC

Target Based Change Data Capture Using Business Objects Data Services

Hope the above links will be useful for you to understand Table comparison.


Arun Sasi

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question