Skip to Content
avatar image
Former Member

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

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

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 16, 2017 at 07:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 16, 2017 at 07:39 AM

    Use left outer join

    Add comment
    10|10000 characters needed characters exceeded