Search found 10 matches

by eimhelper01
Thu Jun 12, 2014 1:27 am
Forum:
Topic: Error while importing CSV file in to Metadata Workbench
Replies: 2
Views: 3572

I've encountered same issue on client site with SSL service tier connection. I was able to import normal Ext. Data Source assets via istool see (http://datastage4u.wordpress.com/2012/09/15/istool-command-line/). Unfortunately I cannot import Custom Attribute Values belonging to EDS in either Workben...
by eimhelper01
Wed Jun 20, 2012 7:34 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: It takes extremely long time to run IA reports
Replies: 7
Views: 4979

Really very good thoughts regarding performance. Column analysis is not that slow, took around 2-3 hours to finish all of them. I didn't feel anything strange in column analysis. Now, I can go to Column Analysis, the view detail to see FD. Summary Statistics report is not that slow, just checked the...
by eimhelper01
Tue Jun 19, 2012 7:15 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: It takes extremely long time to run IA reports
Replies: 7
Views: 4979

Not 400 rows, my fault, 400 columns. biggest table is around 0.5 million rows.

It could because the workload is big, then it is slow.

However, I suspect IA is not function properly, then show extremely slow performance.

Any way of checking if IA is function properly ?
by eimhelper01
Tue Jun 19, 2012 5:54 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: It takes extremely long time to run IA reports
Replies: 7
Views: 4979

Around 20 tables, however, most of them are very small. The big tables only have around half million rows. maybe around 400 rows of these 20 tables are profiled. It is a good idea that I may should tick off some columns not very meaningful. However, at this stage, I just want to take a rough look at...
by eimhelper01
Tue Jun 19, 2012 5:39 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: It takes extremely long time to run IA reports
Replies: 7
Views: 4979

It takes extremely long time to run IA reports

I am profiling my database in SQL Server 2008. Column analysis is finished OK, then I am using report template to generate some profiling reports. However, these reports takes extremely long time to finish. Some of them take around 2hours. All Frequency distribution reports, they might be big, they ...
by eimhelper01
Thu Apr 12, 2012 11:27 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to read data from IADB
Replies: 6
Views: 5714

How to read data from IADB

I want to write a program to extract profile data from IADB, then generate my own report on top of it.

Anyone know the metadata of IADB ?

Just connect to IADB, heaps of strange table names.
by eimhelper01
Wed Mar 07, 2012 9:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage Producing Malformed XMLs
Replies: 1
Views: 1710

XML Stage Producing Malformed XMLs

Hi all, I'm using Datastage 8.5 fp1 and I'm running into an odd issue where the new XML Stage generates malformed XML documents which do not conform to the xsd which I fed it in the Composer. The XSD itself isnt terribly complex though it is quite large and has ~200+ fields - with a total of around ...
by eimhelper01
Mon Feb 20, 2012 6:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to show favorite reports only
Replies: 1
Views: 2984

How to show favorite reports only

In IA report section, go to saved reports, there is a menu to mark them as favorite reports.

Just wondering how I can show favorite reports only since I only need them.
by eimhelper01
Thu Oct 27, 2011 12:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Will Slowly Changing Dimension stage handle Delete ?
Replies: 10
Views: 11025

My SCD Stage is not handling delete. If i delete a records from the source, I am expecting the reference data need to mark it as closed. But for some reason it is not happening!! My first question is, if i delete a record from the source whether it should mark the record as "Close" in ref...
by eimhelper01
Wed Aug 10, 2011 1:33 am
Forum: General
Topic: Integrate Versioning system with DS 8.5
Replies: 2
Views: 2692

I'm also looking to integrate with subversion also for source control and I have some questions: 1. What are the pain points for getting manager to work with subversion? 2. Also were there any show stoppers when packaging and deploying into another project via subversion? I'm using DS8.5 in UNIX wit...