I have a query defined on an ODS (ODS1). In one of the keyfields (K1) of the ODS, delta data has been loaded. It has two navigational attributes (NAV1 and NAV2). In K1,
the data is:
When i execute the query, the output is as follows:
What might be the reason for getting '#' in the output for 2 of the records.
I have another Key field (K2) in ODS1. K2 has a navigational attribute (NAV3).
Even though this attribute is checked in the Navigational attributes section of the ODS,
i can't find this field in the Data part (left wndow) section of the query designer defined on this ODS.
Any help will be greatly appreciated.