Search found 2886 matches

by qt_ky
Wed Jun 11, 2014 7:06 pm
Forum: General
Topic: Metadatawork bench clarification
Replies: 3
Views: 894

Check with the party who purchased your license(s) and/or check with the party who your license(s) were purchased from. If the software was purchased from IBM then you can usually view your entitlements on the IBM Passport Advantage web site, which is on www.ibm.com.
by qt_ky
Wed Jun 11, 2014 9:56 am
Forum: General
Topic: Datastage QualityStage License
Replies: 4
Views: 1671

Re: Datastage QualityStage License

Infosphere Information Server Enterprise Edition for Datastage Double check the product names, editions, and offerings carefully, and also confirm both of your questions directly with a sales person. I don't see an exact match on the IBM web site. Here is what the IBM web site says as of now (it ma...
by qt_ky
Wed Jun 11, 2014 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 3578

Oh, I see now in the first example, the </Descriptions> tag is not where you expected to find it. Is the XML coming to your job in that way, or do you have a job producing it in that way?
by qt_ky
Wed Jun 11, 2014 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchamdin Utility
Replies: 6
Views: 2506

orchadmin delete command options: -f options makes a force delete. If some nodes are not accesible then -f forces to delete the dataset partitions from accessible nodes and leave the other partitions in inaccesible nodes as orphans. -x forces to use the current config file to be used while deleting...
by qt_ky
Tue Jun 10, 2014 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Limit to Multiple instance of sequences and D's parallel job
Replies: 5
Views: 2173

With the default 9.1 settings, approximately 150 jobs can run concurrently and/or be queued (according to IBM). See the following two IBM Technotes FAQ links for details. 1. Describes settings you may change to tune towards running a larger number of jobs: Tuning the UVCONFIG parameters for IBM Info...
by qt_ky
Mon Jun 09, 2014 7:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find whether a substring is present in a field
Replies: 7
Views: 3026

Consider loading the "input" records into a reference table and taking the "reference" codes as your input into a sparse lookup on the reference table WHERE RECORD LIKE %CODE%.
by qt_ky
Fri Jun 06, 2014 10:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Flat files
Replies: 0
Views: 1120

To avoid the mix-up, choose a null field value that is completely different from actual values in the data, or use the Data Set stage instead of exporting to sequential files.
by qt_ky
Fri Jun 06, 2014 10:44 am
Forum: General
Topic: Infosphere Information Server 9.1 - License
Replies: 2
Views: 1002

My organization does not have an "Information Server license" so to speak. We have a plethora of licenses for each individual product component in the suite. IBM offers the software in a variety of editions and bundles. Please check directly with an IBM sales person. I would be curious to ...
by qt_ky
Fri Jun 06, 2014 7:15 am
Forum: General
Topic: Choosing right ETL tool to build new DW enviroinment
Replies: 5
Views: 2853

Feasible indeed. DataStage is highly scalable and works very well with Oracle. Here are a few overviews you may find interesting: IBM Knowledge Center - Parallel processing in InfoSphere Information Server IBM Knowledge Center - Overview of InfoSphere Data Click You may also contact an IBM sales rep...
by qt_ky
Fri May 30, 2014 2:38 pm
Forum: General
Topic: Logical Node vs Physical Node
Replies: 4
Views: 2552

And don't forget virtual servers and virtual CPUs... :wink: A physical processor chip (CPU) can have many physical processor cores, all of which can be virtualized. It can be confusing without fully qualifying everything. A single physical node in a grid could consist of a 4 processor core SMP system.
by qt_ky
Fri May 30, 2014 2:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Adding columns in transformer (Numeric)
Replies: 16
Views: 6197

Need more info... Are those times of day or elapsed times?

If elapsed times, then the first column (hours) may go over 23 hours. 4321:59:59 could be a valid elapsed time.

Likewise, if your total is over 23:59:59 then what is your rule on how to output the result?
by qt_ky
Fri May 30, 2014 9:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NULL Handling in transformer
Replies: 12
Views: 7202

I have found the string "NULL" contained within various source systems (i.e. NAME = "John NULL Doe"). Just one of many surprising data quality issues... :evil:
by qt_ky
Fri May 30, 2014 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Information Server to FileMaker Pro System
Replies: 1
Views: 1045

If they were to make a jdbc driver for your operating system, then maybe.

Chapter 5 shows minimal operating system support.

https://fmhelp.filemaker.com/docs/13/en ... _guide.pdf

Contact FileMaker support with your operating system to see if they will produce a driver.
by qt_ky
Thu May 29, 2014 12:36 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Reporting on full table column analysis
Replies: 3
Views: 3572

IA has many reports available to choose from. Have you looked under the Home menu / Reports / IA category / Column Summary category?