Search found 135 matches
- Fri Sep 08, 2017 12:59 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA Cannot Analyze the data error
- Replies: 5
- Views: 17227
- Fri Jul 21, 2017 1:57 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Reuse data rule definition in Datastage jobs
- Replies: 2
- Views: 16395
- Fri Jul 21, 2017 1:50 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA Data Quality Rules
- Replies: 5
- Views: 8593
- Fri Jul 21, 2017 1:38 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA Cannot Analyze the data error
- Replies: 5
- Views: 17227
IA Cannot Analyze the data error
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 ref...
- Thu Mar 09, 2017 11:33 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Global Logical Variables
- Replies: 4
- Views: 6445
- Fri Jan 06, 2017 10:39 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Global Logical Variables
- Replies: 4
- Views: 6445
- Wed Jan 04, 2017 3:07 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Global Logical Variables
- Replies: 4
- Views: 6445
Global Logical Variables
We are on v11.3 and cannot get GLVs to work. Even just creating them, I cannot save a literal value like numeric 1116. It goes thru the motions of saving, but when I reopen the GLV, the value is gone.
Has this happened to you? If so, did you come up with a solution?
Thanks in advance.
Has this happened to you? If so, did you come up with a solution?
Thanks in advance.
- Wed Nov 16, 2016 12:12 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to SELECT the MAX of a column in a virtual table?
- Replies: 6
- Views: 7407
- Mon Nov 14, 2016 8:44 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to SELECT the MAX of a column in a virtual table?
- Replies: 6
- Views: 7407
- Fri Nov 11, 2016 9:11 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to SELECT the MAX of a column in a virtual table?
- Replies: 6
- Views: 7407
- Thu Nov 10, 2016 3:13 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to SELECT the MAX of a column in a virtual table?
- Replies: 6
- Views: 7407
How to SELECT the MAX of a column in a virtual table?
I am trying to create a virtual table that would only select the MAX of a column. I cannot find a way to use a function, e.g., MAX, on the columns that are selected in creating a virtual table.
For example:
EP_ID
300
400
150
277
I only want the row where EP_ID is 400.
Thanks in advance.
For example:
EP_ID
300
400
150
277
I only want the row where EP_ID is 400.
Thanks in advance.
- Wed Mar 09, 2016 10:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when checking composite operator at run-time
- Replies: 5
- Views: 4552
Sorry, I cannot dump the job score of the particular run. It seems our job logs are purged constantly. However, I did two things: - put a Transformer between the Data Rule stage and the sequential file - removed length/precision of 38/10 for an integer column I don't know which one fixed the problem...
- Mon Mar 07, 2016 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when checking composite operator at run-time
- Replies: 5
- Views: 4552
Error when checking composite operator at run-time
I'm getting this error AT RUN-TIME. I've searched here and on Google and the search results are only about compilation errors. The job is pretty basic: Oracle source goes to a Data Rule stage where I check for duplicates on a combination of 3 fields and output to a sequential file. Here is the full ...
- Tue Feb 09, 2016 5:16 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to communicate rule analysis results
- Replies: 5
- Views: 7926
- Tue Feb 09, 2016 5:12 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: What is IA's ROUND function?
- Replies: 3
- Views: 5197