DSXchange

Hi,
We are Joining table A Full Outer Join B..and target fields are from both the tables.There are couple of records which are not matching Join and are coming with NULL Values for the fields which are coming from A &B.I tried NULL Handling but records are again getting dropped.
Suggestions are appreciated...

Thanks

ajay wrote:Hi,
We are Joining table A Full Outer Join B..and target fields are from both the tables.There are couple of records which are not matching Join and are coming with NULL Values for the fields which are coming from A &B.I tried NULL Handling but records are again getting dropped.
Suggestions are appreciated...

Thanks

Haven't you read the top post of the forum that post descriptive topics,

I am unable to get any clue from what you have written

2 things that can be found are

1. You are performing full outer join
2. Records are getting dropped.

can you post the warning, what you have done to handle nulls and

check whether you have used some manipulation function on input column without handling null


this type of topics has been discussed many times just waiting for you to hit the search button. so hit that

Ensure that all columns in the Join stage are marked Nullable.