Customization of input source results in incorrect data

Technote (troubleshooting)


Problem(Abstract)

When adding a new table to an existing dimension, the test results show no data being returned.

Symptom

NULL values where data is expected


Cause

Two tables were being joined on a VARCHAR field. However, in one table, the field was described as VARCHAR(4) and the other it was a VARCHAR(1).

Environment

SQL Server 2008 R2 source database

Diagnosing the problem

Individually, each table contained data and select statements show that the columns have similar values.

Resolving the problem

Cast the VARCHAR(1) field to a VARCHAR(4) field so that the join will succeed and data will be returned.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Analytic Applications
Adaptive Warehouse

Software version:

8.4.2, 10.1

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1616885

Modified date:

2012-11-09

Translate my page

Machine Translation

Content navigation