Page 1 of 1
lookUp stage doesn't match records
Posted: Fri Aug 03, 2012 1:38 pm
by ashishm
Hi,
I have a previous project's job in which there's a lookup stage. Right now this LookUp stage doesn't match records eventhough there is a match between the source link and the lookup link, how could that happen? It's an urgent task for me to figure it out, can anyone help me on this issue? Thanks in advance.
Posted: Fri Aug 03, 2012 2:45 pm
by chulett
Typically that would be because the values do not in fact match. It could be as simple as extra spaces at the end of one value: trying to match "A" to "A " for example. I'd start with that.
Posted: Fri Aug 03, 2012 4:21 pm
by ray.wurlod
We don't do "urgent", particularly on weekends. If you need urgent, sign up with your official support provider for premier support, and learn just how much urgent costs.
DSXchange is an all-volunteer site whose members post as, when and if they can.
Re: lookUp stage doesn't match records
Posted: Sun Aug 05, 2012 9:16 pm
by SURA
Capture the reject data into a file in the lookup stage and see how the data is?
Write a query (If your reference is table) and in the where clause pass this data and see how the data is?
As Ray said, this is not the place to get ASAP. Whereas if you take out "urgent" from your mind, yourself can find the solution.
Posted: Sat Aug 11, 2012 6:14 pm
by kduke
I would also make sure metadata matches. If your keys are char and one is varchar that could cause a problem. If your case does not match that make cause a problem.