DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 403 matches
Author Message
 Topic: What is ODF and where is it documented?
JRodriguez

Replies: 3
Views: 129

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Feb 08, 2018 6:45 pm   Subject: What is ODF and where is it documented?
IBM Information Server Open Discovery Framework (ODF)
In the latest versions of Information Server IBM added open source services, specifically the Apache Framework (Zookeeper, Kafka,solr) and there ...
Resolved
 Topic: Encrypted connection to SQL Server
JRodriguez

Replies: 4
Views: 402

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 Jump to:   



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