hi,
this is simple but i am stuck..
i am doing a dynamic lookup on my target..but for some reason
null value gets inserted into the target table..
like in my source if i have IN_POS_ID is null and in the lookup i have a condition
IN_POS_ID = POS_ID. I do not want to insert records where the POS_ID is null but it still gets
inserted into the target table..i used a Router and update strategy after my lookup for insert and updates.
in lookup but still a null record gets inserted ..
thanks for ur help!
this is simple but i am stuck..
i am doing a dynamic lookup on my target..but for some reason
null value gets inserted into the target table..
like in my source if i have IN_POS_ID is null and in the lookup i have a condition
IN_POS_ID = POS_ID. I do not want to insert records where the POS_ID is null but it still gets
inserted into the target table..i used a Router and update strategy after my lookup for insert and updates.
in lookup but still a null record gets inserted ..
thanks for ur help!