Query Designer/Output problems

Hi Guys,

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:

NAV1 NAV2

1000 100

2000 100

3000 100

4000 100

When i execute the query, the output is as follows:

NAV1 NAV2

1000 100

2000 100

3000 #

4000 #

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.