Revisiting this question...
Running on IA 11.3.1.2
Data source: SQL Server
We are trying to access an nvarchar field which the data owner advises could be up to 2GB. IA says it 'Cannot Analyze' the data. Every rule that references it fails. I've even tried LEFT(fieldname, 250) but again the mere reference to the field makes the job fail.
I've checked with our technology support and they assure me nvarchar support is already turned on in odbc.ini.
Anything else we could look into?
IA Cannot Analyze the data error
IA Cannot Analyze the data error
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Sr Consultant, Data Quality
San Antonio TX
And... done. Split from this topic.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
See if either of this is related.
http://www-01.ibm.com/support/docview.w ... wg21376824
http://www-01.ibm.com/support/docview.w ... wg21698836
http://www-01.ibm.com/support/docview.w ... wg21376824
http://www-01.ibm.com/support/docview.w ... wg21698836
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As soon as the metadata specifies more than 500 characters, IA will not attempt to analyze. The reasoning is that meaningful statistics are unlikely to be found in such fields, which are typically comments, descriptions and the like - text, basically.
What would you expect out of such a field? What would the frequency distribution look like? Even if you found 100% cardinality, there's no database in existence that could or would accept such a data type as a key column; imagine the size of the primary key index!!!
What would you expect out of such a field? What would the frequency distribution look like? Even if you found 100% cardinality, there's no database in existence that could or would accept such a data type as a key column; imagine the size of the primary key index!!!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.