DSXchange

input is A.txt file(10 records) which has fileld C1,C2...char field...
ref i/p is B.txt(7 records) which has field C1,C3...char filed....
lookup has continue condition....lookup key is C1...
In lookup the o/p fields are C1,C2,C3
now o/p of lookup is 10....(7 records matching)

Now in later stage if I use any null function on C3 field (trim/is null/null to empty) it is not able to figure the 3 records for which c3 is null....


The job was totally running fine in Dev env.....Now in QA it is not working...Not able to understand why null value is not coming from lookup...

Is ther any env settings problem...
Please suggest...

What is different between dev and QA environments? Look very carefully - something is different, obviously.

Apparently we are not able to find any difference.Is there any special APT parameter to recognize null value..or do we need to chack character set used by datastage..
Please suggest...

what is optput for C3 columns after the lookup stage, for those 3 records you are not getting match?