DSXchange

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

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

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

The only issue with doing in SQL is that I have 20+ field in the code/value set with 8 or so being numeric.

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

We were trying to move away from server jobs.
We're trying to move away from hash files.
I was taking advantage of the switch stage for all of the code/value pairs as well as the additional stages available in parallel addition.

Is this a known issue in parallel addition?

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

sftp -V does not work..
However...
ssh -V
OpenSSH_4.3p2, OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008

Not open source..
Linux /usr/bin/sftp

password-less setup using public key generation and entries added to know_hosts file.

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

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

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.

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

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

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