Search found 186 matches
- Tue Nov 12, 2013 10:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830
- Tue Nov 12, 2013 7:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830
Thanks, Cannot keep Float as datatype in OC connector, its getting failed. Simple design. 1. OC connector -> Transformer -> Peak Stage Result - >Getting failed, source datatype is Float 2. OC connector -> Transformer -> Peak Stage Result - >Getting Success. source datatype is Double I did conversati...
- Tue Nov 12, 2013 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830
- Mon Nov 11, 2013 11:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varbinary datatype in source
- Replies: 2
- Views: 1815
varbinary datatype in source
Hi, Please need your help to the data issue. One of the column from the source (SQL server) is [varbinary](max) NULL. Its having the value as below 0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF Few values exceed the lenght upto 355902. Job design ODBC Connector -> Copy -> DataSet. W...
- Mon Nov 11, 2013 9:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830
- Mon Nov 11, 2013 6:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830
DFLOAT into column SFLOAT issue
Hi, Please need your help to resolve fatal error issue. The job design is ODBC Connector -> Copy -> DataSet When I run the job, Iam getting the fatal error as below OC_Connector: Schema reconciliation detected a size mismatch for column ConversionFactor. When reading database column DFLOAT into colu...
- Sun Nov 10, 2013 11:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [odbc sql server driver] Invalid descriptor index
- Replies: 2
- Views: 8253
- Fri Nov 08, 2013 5:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [odbc sql server driver] Invalid descriptor index
- Replies: 2
- Views: 8253
[odbc sql server driver] Invalid descriptor index
Hi Guys, Please need your help to resolve this issue. Job design ODBC Connector -> Copy -> DataSet. When I give the below SQL query in ODBC Connector, Iam able to view data. select ID, Date, status, Description from Headcount But when I give below SQL query, its having issue. select ID, Date, status...
- Thu Aug 08, 2013 11:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse look up
- Replies: 5
- Views: 2619
- Wed Jul 24, 2013 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file partition
- Replies: 3
- Views: 1372
- Wed Jul 24, 2013 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file partition
- Replies: 3
- Views: 1372
Sequential file partition
Hi,
Got a question from DS exam.
You have a job that reads in sequential file followed by transformer stage. When you run this job, which partitioning method will be used by default?
The answer is Round Robin.
Any idea why.
Thanks,
Got a question from DS exam.
You have a job that reads in sequential file followed by transformer stage. When you run this job, which partitioning method will be used by default?
The answer is Round Robin.
Any idea why.
Thanks,
- Tue Jul 02, 2013 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning
- Replies: 19
- Views: 13145
1) Is key based partition needed in parallel jobs ? Keyed partitioning is used when business rules (for example, Remove Duplicates) or stage requirements (for example, Join) require processing on groups of related records 2) Is Join stage running on single node ? If the configuration file is having ...
- Sat Mar 30, 2013 12:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal conversion
- Replies: 3
- Views: 2204
- Fri Mar 29, 2013 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal conversion
- Replies: 3
- Views: 2204
String to Decimal conversion
Source file has varchar2(20) but target table has Decimal(20,6).How to convert varchar2 to decimal.i tried using StringToDecimal() function.But output coming as all ZERO's.Target values as 00000000000000.000000
Please suggest your thoughts on this ....
Please suggest your thoughts on this ....
- Thu Dec 13, 2012 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to view sequential file in parallel
- Replies: 4
- Views: 1731
Re: Unable to view sequential file in parallel
do initial verification how many no.of columns in the source file and how many no.of columns specified in the job. It's looks columns mismatch.... Hi, I have converted a fixed width file to a csv file using a server job. Then in the paralle job when I try to open the csv file I get the following err...