Search found 78 matches
- Thu Oct 15, 2015 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key Generator special character in password issue
- Replies: 4
- Views: 3349
Surrogate Key Generator special character in password issue
I have recently run into the issue where the Oracle password contains special characters. This causes job failure for jobs that contain a Surrogate Key Generator transform. Search of the forum provided a solution.. http://www.dsxchange.com/viewtopic.php?t=145477 "check your oracle password, is ...
- Mon Aug 03, 2015 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
Solution
For those interested, here is how I solved the problem: 1. Defined target column definition to Decimal(38,10). 2. For each column I used the following logic: If IsNull( lnk_mrg.THE_VALUE ) then SetNull() Else if Num(lnk_mrg.THE_VALUE) and index(lnk_mrg.THE_VALUE,'E',1) > 0 then Field(lnk_mrg.THE_VAL...
- Fri Jul 31, 2015 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
I'm not sure. Maybe it is not. I'm currently doing a Select key, code, value from c_v_table. Code is varchar(256), value is varchar(256). Then I have pairs like code:'name','value:Joe Smith'; code:'income', value:'290000'; code:'interest-rate',value:'3.875'; ... I used a switch to parse the values a...
- Fri Jul 31, 2015 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
- Fri Jul 31, 2015 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
there is a switch for the 20+ different field value types that then use the merge stage to bring all the values together into columns then into a SCD stage that takes care of dimension changes. Converting the swith to a transformer with 20+ outputs seems counter productive. Using the SCD is pretty c...
- Fri Jul 31, 2015 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
- Thu Jul 30, 2015 10:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar numeric to Oracle decimal conversion
- Replies: 12
- Views: 8119
varchar numeric to Oracle decimal conversion
I'm converting a source Oracle Code/Value table where the source Value column is defined as Varchar2(256) to an Oracle Decimal(32,10). The values that I need to convert are very diverse (ie: '432,000,200', '1.45e6', '567234.75', '324567.4','123456.789') My solution: 1. Read the values from Oracle in...
- Fri Dec 07, 2012 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Transform in sftp mode.
- Replies: 5
- Views: 3234
- Thu Dec 06, 2012 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Transform in sftp mode.
- Replies: 5
- Views: 3234
- Thu Dec 06, 2012 1:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Transform in sftp mode.
- Replies: 5
- Views: 3234
FTP Enterprise Transform in sftp mode.
Has anyone seen an issue after setting up a passwordless sftp connection between servers and then attempted to use the FTP Enterprise transform as a target and set to sftp mode? I can perform a command line sftp 'put' to the target server without any issues. However, when attempting to use the FTP E...
- Mon Nov 05, 2012 4:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Greenplum Performance Load Tips?
- Replies: 3
- Views: 2583
Apparently there are logs generated as inserts are performed. We were inserting several million records and it generated large log files on the Greenplum server (appliance). I forgot the size.. But apparently it was large enought that the DBAs let me know it was not appreciated. ;-) I'm not sure if ...
- Mon Nov 05, 2012 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Greenplum Performance Load Tips?
- Replies: 3
- Views: 2583
Greenplum Performance Load Tips?
I'm attempting to load a Greenplum database using the provided ODBC drivers. Ugh!!!
The slow performance and log build up is making this a serious issue. The read performance is not bad at all.
Has anyone found a better method for doing fast appends to Greenplum?
Thanks in advance.
The slow performance and log build up is making this a serious issue. The read performance is not bad at all.
Has anyone found a better method for doing fast appends to Greenplum?
Thanks in advance.
- Wed Apr 25, 2012 6:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQLBuilder - Invalid pointer
- Replies: 1
- Views: 1411
SQLBuilder - Invalid pointer
I used SQLBuilder in an Oracle Enterprise stage to create a select statement for Oracle 10g on an AIX install and Windows XP client on DataStage 8.01. If I attempt to re-edit the the select statement using SQLBuilder I get an error.... 'An error occured invoking the SQL Builder. Invalid Pointer.' An...
- Mon Mar 26, 2012 9:41 pm
- Forum: General
- Topic: Parameter Set usage?
- Replies: 2
- Views: 1686
As always, Thanks Ray for the info! I was playing around with the jobs and realized that if I have a Sequence with the Same Parameter Set name defined, I can click on the properties of the Job stage, click on the Parameter Set within the stage and click on the Insert Parameter button and it automati...
- Mon Mar 26, 2012 7:51 pm
- Forum: General
- Topic: Parameter Set usage?
- Replies: 2
- Views: 1686
Parameter Set usage?
If I have several datastage jobs that have the same parameter set defined as an input parameter to the job and then add these jobs to a job sequence. Is there a way to specify that the same parameter set values (a set of values with the same name) be used by all of the jobs within the sequence? Or, ...