Search found 18 matches

by andy心&#262
Wed Oct 29, 2008 11:50 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: an error of load database metadata
Replies: 3
Views: 3439

I check the log main::Init: Unable to create Hash2Sql object for table 'SystemConfig': Hash2Sql::new: No columns found for table 'SystemConfig'. Undefined table? I find others has a same issue before, he used oracle as repository. His fix the issue by changing oracle standard driver into DataDirect ...
by andy心&#262
Tue Oct 28, 2008 7:04 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: an error of load database metadata
Replies: 3
Views: 3439

an error of load database metadata

OS:windows XP SP3 PS: 7.5.1 for windows DB:sql2000(SP4) I am learning PS by myself now.When I load database meta data, I get an error "Meta Data Loader Done. Process halted due to problem(s) ". Hope sb. can help me. Here is the detail: 10-28 20:33:21: MyNoetebook\GenOdbc2Mxf: 5039 0 Progra...
by andy心&#262
Tue Oct 28, 2008 2:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: join question
Replies: 9
Views: 3180

join question

Join tables in oracle database server at first, the system bottleneck is oracle db. And if the db is busy, you will get the error that the snapshot is too old, it is not an error of datastage. Extract tables then use datastage to join, the bottleneck is transformstage in the job. First method will b...