Search found 93 matches

by tcj
Thu Oct 28, 2010 6:37 pm
Forum: General
Topic: Dubious 'Standards'
Replies: 8
Views: 1818

Seems like either the architects or DBA's don't trust their developers to write SQL correctly.
by tcj
Thu Oct 28, 2010 5:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The IOD 2010 Demo of the new DataStage XML Transformer
Replies: 6
Views: 2475

Ernie,

How does v8.5 handle the xml pack 2 stages in existing jobs? Does it migrate the old xml stages to the new xml stages or does it need to be done by hand?
by tcj
Wed Oct 20, 2010 4:14 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Can IA see views (versus physical tables)?
Replies: 3
Views: 1684

I can confirm that IA can see views.
by tcj
Wed Oct 13, 2010 6:20 pm
Forum: General
Topic: Information Server 8.5 released this week!
Replies: 21
Views: 7891

Finally.

No support for solaris I see.
by tcj
Thu Sep 09, 2010 6:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Large xml file
Replies: 5
Views: 1788

Is the job aborting when you are trying to read the xml file or while you are creating it?

Tim
by tcj
Thu Aug 12, 2010 10:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cobol ,PL/sql
Replies: 3
Views: 950

Just somethings off the top of my head.

Datastage Pros over PL/SQL:

Quicker to build
Out of the box error logging
Out of the box audit information logging
Easier to maintain
Easier to debug

It is very easy to write bad pl/sql compared to a bad datastage job. Some people might not agree with me but from my experience on various projects in the last 10 years has shown me otherwise.
by tcj
Wed May 26, 2010 6:09 pm
Forum: General
Topic: IOD EMEA Day Two
Replies: 11
Views: 6455

Ray,

Any word on when this will be put in?

Migration tool automatically converts "old" database stage types to connectors during upgrade.

Going into the next version of DataStage? It will be quite handy for the migration I have to do.

Tim
by tcj
Wed May 26, 2010 6:07 pm
Forum: General
Topic: IOD EMEA Day Two
Replies: 11
Views: 6455

This line scares me.

Looping (loop variables separate from stage variables). This allows, for example, multiple output rows to be generated on one output link from a single input row.

That in the hands of a bad dev is dangerous.
by tcj
Fri May 21, 2010 12:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage on Windows
Replies: 2
Views: 1133

Just migrating server edition to a unix server doesn't mean you are going to make use of the parallel architecture.

Are you proposing to go to parallel edition on the unix server?
by tcj
Sun Apr 18, 2010 10:29 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Does IA convert tasks into SQL and execute?
Replies: 3
Views: 1689

I would strongly suggest not profiling on a live production database. Profiling can easily bring a production database to its knees.

Best practice method is to run profiling on a copy of the production database.

Tim
by tcj
Sun Apr 18, 2010 9:55 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Accessing, using IADB
Replies: 9
Views: 4231

Yes they are cryptic which makes it hard sometimes to figure out what result table belongs to which business rule profile.

Oh just a heads up on a feature/bug/issue that you might hit if you are profiling an Oracle database. When you run a report on the output of a business rule profiling job that includes a field defined as a number. The value in the report will come out as a exponential number. It has to do with how the 3rd party ODBC drivers import the data.

You will need to write a script which will change the field type in the business rule profiling result tables in the xmeta database to get around this problem. I can't remember if it was Decimal to number.

Tim
by tcj
Thu Apr 15, 2010 11:32 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Accessing, using IADB
Replies: 9
Views: 4231

If you set up a new user with read only access on the database server which xmeta has been setup on then yes you can use Oracle BI.

Have you looked at the table names which information analyzer uses to store the results?
by tcj
Sun Apr 11, 2010 7:53 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: What version introduced Data Rules?
Replies: 6
Views: 3870

I hope you have some good hardware to use for the business rules profiling.

You will find a big increase in the resources for business rules profiling.
by tcj
Tue Oct 06, 2009 12:31 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Difference between cardinality and uniqueness
Replies: 3
Views: 2409

The uniqueness count should be the same value as the total actual row count if you are doing a column analysis run on a primary key field.

For example:

1
2
3
4
5
6
7
8

The uniqueness count would be 8 as there are 8 records which only occur once.

The example I supplied the uniqueness count is 1.

There is only one date which occurs once. That is the date
03-01-2009.

Hope that clears that up.
by tcj
Mon Oct 05, 2009 6:34 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Difference between cardinality and uniqueness
Replies: 3
Views: 2409

Think of cardinality as the count of distinct values within the column.

For a field like transaction date you would expect a low number of distinct values.

If you had the values:
01-01-2009
01-01-2009
02-01-2009
02-01-2009
03-01-2009

You would expect a value of 3.

For a field, which is a primary key, you would expect a high number of distinct values.

Uniqueness count is the count of unique values.

For a field like transaction date you would expect a low number. You wouldn't expect to find many dates, which have occurred once.

If you had the values:
01-01-2009
01-01-2009
02-01-2009
02-01-2009
03-01-2009

You would expect a uniqueness count of 1.

For a field that is a key you would expect a high number. The uniqueness count should be the same value as the total actual row count.