How can we achieve table comparison without using table comparison transform.

[former_member342250]

Can someone please explain in brief how can we achieve table comparison functionality without actually using it in BODS.

Thanks in advance.

[Former Member · Accepted solution]

Another way is

source==>query==>query_lukpext==>case==>query_1==>map_operation==>target(for insert)

==>query_2==>map_operation==>target(for update)

write 2 conditions in case

1 condition==> lookup.id is null (for insert)

2 condition==>lookup.id is not null and source.cost<>lookup.cost or source.location<>lookup.location (for update)

In second condition select the columns which are the columns u want to compare

Note: Two targets are same table

[Former Member]

Use left outer join