Question on PX lookup
Posted: Wed Dec 08, 2010 6:10 pm
Hi All,
I know this is a simple question. However I hear different answers from different people and I dont know whats the truth.
Consider the following scenario in a PX job.
Job reads field A(char 6) from table X. In a lookup stage input link it is reading fields B & C where C is of VARCHAR 120 and B is the integer key. For the lookup to happen properly do we have to cast the field C to VARCHAR 6 after trimming when we do the read from the lookup table before it reaches the lookup stage?
Thanks!
Chanaka
I know this is a simple question. However I hear different answers from different people and I dont know whats the truth.
Consider the following scenario in a PX job.
Job reads field A(char 6) from table X. In a lookup stage input link it is reading fields B & C where C is of VARCHAR 120 and B is the integer key. For the lookup to happen properly do we have to cast the field C to VARCHAR 6 after trimming when we do the read from the lookup table before it reaches the lookup stage?
Thanks!
Chanaka