Focal Point
[CASE-OPENED]DATREC vs Internal - Missing values (Migration issue)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8777075386

August 25, 2016, 03:39 PM
Avatar
[CASE-OPENED]DATREC vs Internal - Missing values (Migration issue)
Hello,
I have strange finding afer we migrate to 8.1 from 7702.

When we use target transformations with conditions like "IF XXXX EQ MISSING THEN 'this' ELSE 'that'".
In 7702, SQLIN is in INTERNAL format and the above one works well.

In 8.1, SQLIN is in DATREC format and the above transformation seems not working as it is not able to identify MISSING as MISSING.

When I check SQLIN data, I see '.' which is missing but transformation is unable to identify '.' as missing in DATREC or 8.1 version.

Any thoughts on this please. Thanks very much.

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
August 25, 2016, 04:03 PM
Avatar
Just found out that ...

With DATREC - Transformation is working up to 1134 rows and unable to identify MISSING ('.') from 1135th row.

This is strange.


WebFOCUS 8
Windows, All Outputs
August 26, 2016, 02:37 PM
Avatar
Any help? Thanks.


WebFOCUS 8
Windows, All Outputs
August 29, 2016, 09:27 AM
Marina
Hello,
This question, as I see it, needs to be viewed by the customer support department. Please open a hottrack case and upload your Data Flow (.fex file) along with the related synonyms (*.mas and .acx files) to the case.

Thanks.
August 29, 2016, 11:38 AM
Avatar
Thanks Marina, a case has been raised.


WebFOCUS 8
Windows, All Outputs