DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 400 matches
Author Message
 Topic: "error": "SELF_SIGNED_CERT_IN_CHAIN"
JRodriguez

Replies: 1
Views: 146

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Wed Oct 25, 2017 5:34 am   Subject: "error": "SELF_SIGNED_CERT_IN_CHAIN"
This is the light version of the procedure. Do your company have a WAS administrator? If yes then ask for help to that group, the procedure is straightforward for a WAS person. If not then just fol ...
Workaround Reported
 Topic: Throttle a DS Parallel job which invokes a Rest Service
JRodriguez

Replies: 3
Views: 310

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 11, 2017 5:28 pm   Subject: Throttle a DS Parallel job which invokes a Rest Service
Well normally we are asked to speed up processes..but it could be done. Here is one way

To the request table add a column to flag the requests records as processed/not processed. Default the value ...
 Topic: Unicode Property at Project Level
JRodriguez

Replies: 2
Views: 283

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 27, 2017 5:32 am   Subject: Unicode Property at Project Level
I believe that the only option at that point -after importing the metadata to the DS jobs- is manually changing the property to Unicode or changing the type to NVarchar/NChar

Yo could try hacking ...
 Topic: istools does not recognise -informationanalyzer option
JRodriguez

Replies: 10
Views: 881

PostForum: General   Posted: Wed Sep 20, 2017 11:55 am   Subject: istools does not recognise -informationanalyzer option
We are at 11.5.0.2 and able to see the Information Analyzer import options...See last line

./istool.sh import -help istool import [ Options ]

Possible values for: Options
Long Name: ...
 Topic: How to process/output only the first of multiple records
JRodriguez

Replies: 2
Views: 293

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Sat Sep 16, 2017 1:39 pm   Subject: How to process/output only the first of multiple records
Hi Manito,
How about a virtual table to represent the right table with the desired records to return only one when joining with the left table? Of course you would need to use regular SQL techniques ...
 Topic: Unicode with RCP?
JRodriguez

Replies: 11
Views: 834

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 12, 2017 5:56 am   Subject: Unicode with RCP?
The Oracle client needs to know the NLS of the target database, just set DS job to go by the NLS of the target database, here is how is done:
-Get the NLS of Oracle database
- Add a NLS_LANG to user ...
 Topic: SQL server login issue
JRodriguez

Replies: 3
Views: 397

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Sep 09, 2017 9:01 am   Subject: SQL server login issue
To connect to SQL Server databases with Windows athentication you would need the DataDirect drivers 7.0 of the SQL Server Wire Protocol driver, the functionality is not supported in previous version ...
 Topic: QualityStage - How to match string with spaces
JRodriguez

Replies: 8
Views: 622

PostForum: IBM QualityStage   Posted: Sat Aug 26, 2017 11:57 am   Subject: QualityStage - How to match string with spaces
I understand the challenge, and can assure you that is a normal situation. This is where QS is a great tool to match records where there are not common keys, but as I mentioned you need a good SME for ...
 Topic: QualityStage - How to match string with spaces
JRodriguez

Replies: 8
Views: 622

PostForum: IBM QualityStage   Posted: Fri Aug 25, 2017 4:12 pm   Subject: QualityStage - How to match string with spaces
There is not an out of the box standardization rule set for products or items, so I would:
- Develop a custom rule set to standardize the products raw input data
- Design matching specification with ...
Resolved
 Topic: Oracle OCI Decimal(38) versus Connector DOUBLE
JRodriguez

Replies: 3
Views: 480

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 18, 2017 7:40 am   Subject: Oracle OCI Decimal(38) versus Connector DOUBLE
....DataStage does not have a data type that match Oracle Number without precision and scale, in your case the scale is not present. DataStage will represent them as double to correctly indicates that ...
Resolved
 Topic: Create a record if entry for a key field does not exist
JRodriguez

Replies: 4
Views: 525

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 15, 2017 6:49 am   Subject: Create a record if entry for a key field does not exist
Read your file, add a transformer with 4 output links
connected to your DB connector
Set the first three links to INSERT NEW RECORDS ONLY, map the account from the file input column and hardcoded ...
Resolved
 Topic: XMETA table OMDMODEL_JOBPARAMETER
JRodriguez

Replies: 11
Views: 781

PostForum: General   Posted: Fri Aug 11, 2017 12:06 pm   Subject: XMETA table OMDMODEL_JOBPARAMETER
If you are referring to  iis.client.site.properties file...one important fact is that the timeout value is expressed in miliseconds....and you might want to have this set to a high water mark due to t ...
Resolved
 Topic: XMETA table OMDMODEL_JOBPARAMETER
JRodriguez

Replies: 11
Views: 781

PostForum: General   Posted: Fri Aug 11, 2017 5:45 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Did you try the workbench purgeOMD command? This istool command allow you to purge the operational metadata by date range, number of record to keep, engine, etc. The id running the command would need ...
Resolved
 Topic: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
JRodriguez

Replies: 40
Views: 3616

PostForum: General   Posted: Thu Aug 10, 2017 10:03 am   Subject: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
Hi Arvind_ds,
Wondering if you get to resolved the issue? A lot of us could learn from this situation ....

We have a similar environment with 11.5.0.1 and Oracle 11g for XMETA, and we are planning ...
Resolved
 Topic: XMETA table OMDMODEL_JOBPARAMETER
JRodriguez

Replies: 11
Views: 781

PostForum: General   Posted: Tue Aug 08, 2017 11:36 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
If the "Generate operational metadata" was enabled also at the job level you will need to disable it and recompile

You could see exactly which jobs are generating metadata, the xml files are named ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours