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
Records are getting dropped from Transformer after Full Oute
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: Records are getting dropped from Transformer after Full
Haven't you read the top post of the forum that post descriptive topics,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
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
Last edited by priyadarshikunal on Sat Feb 16, 2008 6:24 am, edited 1 time in total.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: