Data Insert in BODS 3.2

[#1]

Hello,

I am experiencing a weird issue in BODS3.2.

I use "Task_lookup" to lookup values in target table (task table). "Case" defines when lookup results (look up results of ID) is null, then move to next transformation. Insert maps the information and key generation generate the new key for records I want to insert.

I got records up to case statement but no record count for insert query. The lookup is based on 4 equal conditions.

Lookup logic:

Monitor log:

CASE:

Insert:

Target property.

Any comments is appreciated.

Thanks.

Terry

[Former Member · Accepted solution]

Hi Terry,

Can you use Join instead of lookup.. I know we cannot use target as source in the same dataflow.. try using with sql transform or by staging target data to a staging table and use it for join.

Once i faced similar issue when using multiple conditions in lookup and got the corect output using join.

Create a test job and try this once.

Thanks,

Ravi kiran.

[former_member187605 · Accepted solution]

I know we cannot use target as source in the same dataflow.. 

This is definitely not true!!!