Hi,
I am facing an issue with the lookup stage in DataStage.Please find the details below.
I am having sequential file as source which has a column name as below
column name Datatype
question_description Varchar
Now my requirement is i should have a lookup on the dimension table on question_description column and pass only the records that are matching
I have linked the source column and the lookup column in the lookup stage and enabled the property lookup failure reject or else continue to the target
The issue is i have record What is your name? in the source record and the same record exists in my dimension table, but during the lookup the lookup stage is rejecting the record eevnthough it is existing in the table.
Can anyone please help me to figure out this
Lookup Mismatch of Records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Mon Aug 04, 2008 8:34 am
- Location: Guntur
Lookup Mismatch of Records
Naresh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 21
- Joined: Mon Aug 04, 2008 8:34 am
- Location: Guntur
Hi,
Please find the answers for the questions you have mentioned.
a)The two values are spelled,trimmed and cased identically.
b)The Varchar length has been specified to 256.
Please find the sample record.
What is your name?(Record from source)
What is your name?(Record from lookup table)
Thanks,
Naresh
Please find the answers for the questions you have mentioned.
a)The two values are spelled,trimmed and cased identically.
b)The Varchar length has been specified to 256.
Please find the sample record.
What is your name?(Record from source)
What is your name?(Record from lookup table)
Thanks,
Naresh
Naresh
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 79
- Joined: Thu Mar 22, 2007 4:58 pm
- Location: USA