DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 401 matches
Author Message
 Topic: UTF-8 to UTF-16 conversion in Datastage
JRodriguez

Replies: 1
Views: 121

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 Jump to:   



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