DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 402 matches
Author Message
 Topic: Encrypted connection to SQL Server
JRodriguez

Replies: 3
Views: 173

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 11, 2018 6:43 am   Subject: Encrypted connection to SQL Server
Try the instructions in below link

http://www-01.ibm.com/support/docview.wss?uid=swg21676239
 Topic: UTF-8 to UTF-16 conversion in Datastage
JRodriguez

Replies: 1
Views: 426

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 13, 2017 8:56 am   Subject: UTF-8 to UTF-16 conversion in Datastage
Hi Matt,
Internally DataStage parallel jobs use UTF-16 encoding by default regardless of the encoding of sources and targets. It means that internally the data from one stage to the next flows alrea ...
 Topic: "error": "SELF_SIGNED_CERT_IN_CHAIN"
JRodriguez

Replies: 1
Views: 490

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: 478

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: 449

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: 1404

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: 630

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: 1757

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: 679

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: 1201

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: 1201

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: 778

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: 847

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: 1365

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: 1365

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 ...
 

 Jump to:   



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