Search found 93 matches

by tcj
Wed Sep 30, 2009 7:20 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: automating odbc.ini update
Replies: 3
Views: 2920

If you have the list of the 20 databases then you can just populate the odbc.ini file with the details of the 20 databases.
by tcj
Tue Sep 29, 2009 11:12 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA 8.1 upgrade to 8.1.1 Installation Questions & Guidanc
Replies: 1
Views: 2279

Here is an IBM link about installing patches in v8.1. http://www-01.ibm.com/support/docview.wss?uid=swg27012519&aid=1 You will need a patch for server and client side. Might have to speak to IBM if you don't have both the v8.1.1 patch files. There are a whole bunch of patches which need to be ap...
by tcj
Tue Sep 29, 2009 7:40 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Info Analyzer job aborting with unknown error
Replies: 2
Views: 2397

Is there anymore information in the error message that you can share?
by tcj
Tue Sep 22, 2009 10:52 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Info Analyzer logs
Replies: 2
Views: 2400

Brad, You can rerun the job with the Retain Scripts option selected under the Engine tab. This will retain the datastage job in the ANALYZERPROJECT project. Or Open the web console and browse to the screen Administration->Log Management->Log Views. You will need to set up a custom log view to only s...
by tcj
Tue Sep 22, 2009 12:22 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA Projects Location & job export & Import
Replies: 9
Views: 6718

This is a very good question.

I can't remember reading anything that suggests you can migrate the column analysis type jobs from one server to another server on version v8.1.

Are you on v8.1 or v8.1.1?

Tim
by tcj
Sun Sep 20, 2009 10:05 pm
Forum: IBM QualityStage
Topic: Ask for learning tricks on IBM QualityStage
Replies: 4
Views: 4241

IBM have released a IBM Redbook which covers the topic of QualityStage. Do a search on either google or the IBM website.

It explains QualityStage better than the manuals in regards to samples.
by tcj
Tue Sep 08, 2009 11:26 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Adding business logo to reports.
Replies: 0
Views: 1732

Adding business logo to reports.

Looking at the Information Analyzer manual it states you can "Create a business logo in the report". Anyone has any success in doing this? I can't seem to find an option to do this in the Web console. The manual and redbook both don't seem to give anymore information than the one line I qu...
by tcj
Sun Aug 09, 2009 8:18 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Unable to run Information Analyzer column analysis
Replies: 2
Views: 4680

Have you set up the Analysis Engine and Analysis Database settings under HOME>Anaylsis settings?
by tcj
Thu Sep 18, 2008 12:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance issue with Hashfiles
Replies: 3
Views: 1304

Interesting whitepaper on the subject. I found this link from other post.

http://www.openqm.org/downloads/dynamic_files.pdf

This is the post I found it in. Take note Chulett post down the bottom.

viewtopic.php?t=109212&highlight=modulus
by tcj
Thu Sep 18, 2008 12:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance issue with Hashfiles
Replies: 3
Views: 1304

Are they dynamic or static hashed files? How many rows are being created in the hashed files? I would guess that the hash files on the old 7.5 server have grown over time being dynamic type hashed files. The new hash files on version 8 will probably have been created from new with the default settin...
by tcj
Tue Sep 16, 2008 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: copy hashed file
Replies: 8
Views: 2816

Did you copy over the .Type30 file?
by tcj
Tue Sep 16, 2008 10:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AIX 7.5.3 File System Backup strategy..
Replies: 2
Views: 1262

The running job should be a phantom.

ps -ef | grep phantom

Clients should be a dsapi_slave from memory.

ps -ef | grep slave
by tcj
Tue Sep 02, 2008 10:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Funnel
Replies: 9
Views: 3854

Should be able to use the link collector. Have two sequential links coming into the link collector with a single output from the link collector.

The two sequential links must have the same metadata.

This will merge two sequential files into the one sequential file with the same metadata.
by tcj
Mon Jul 23, 2007 5:27 pm
Forum: General
Topic: Why are we stuck with Datastage ?
Replies: 9
Views: 5380

Wow Vincent I didn't realise there was that much demand for Informatica people in Australia. I didn't think there were too many Informatica shops in Australia?

Alot of the SSIS roles seem to be with Government departments here in SE Qld.
by tcj
Mon Oct 16, 2006 5:30 pm
Forum: Data Integration
Topic: IOD 2006 questions
Replies: 15
Views: 50449

I wish some of the conferences in Oz were like that.

Free video arcade and booze.