DSXchange

Seems like either the architects or DBA's don't trust their developers to write SQL correctly.

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?

I can confirm that IA can see views.

Finally.

No support for solaris I see.

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

Tim

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 f...

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

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.

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?

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

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 i...

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?

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.

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. Ther...

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...