Search found 186 matches
- Fri Dec 20, 2013 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partition Issue
- Replies: 2
- Views: 1324
Partition Issue
Hi Guys, The job design is Seq | v DataSet -> Column_Generator -> Lkp -> Copy -> Oracle connector When I run the job in 2 nodes, Iam getting the count matched between src and target. But when running the job in 1 node, the count is coming less. Partition I have kept Same in all the stages. Lkp refer...
- Tue Nov 26, 2013 3:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8727
- Tue Nov 26, 2013 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8727
- Mon Nov 25, 2013 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8727
- Mon Nov 25, 2013 6:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8727
- Mon Nov 25, 2013 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8727
Integer to Char conversion questions
Hi, Please need your help in converting Integer to Char function. I have the below values as Integer in the source. 123456 654321 I have done a direct map across Integer to Char in Transformer. I am getting the below values 123456?? 654321?? In the target table (Oracle) its defined as Char(8) As sea...
- Tue Nov 19, 2013 10:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Converstion
- Replies: 3
- Views: 2090
- Tue Nov 19, 2013 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Converstion
- Replies: 3
- Views: 2090
Timestamp Converstion
Hi, Please let me know how to convert the following Timestamp to standard Oracle Timestamp format YYYY-MM-DD HH24:MM:SS. 2013-05-28 05:09:03.330000 Is the below correct one. StringToTimestamp(Ln_Transform.HeadcountDate,"%yyyy-%mm-%dd %hh:%nn:%ss.%6") Iam getting the below error Tr_Transfor...
- Tue Nov 19, 2013 2:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to pass data value to next PX job parameter?
- Replies: 7
- Views: 4169
- Mon Nov 18, 2013 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to pass data value to next PX job parameter?
- Replies: 7
- Views: 4169
- Mon Nov 18, 2013 5:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to pass data value to next PX job parameter?
- Replies: 7
- Views: 4169
How to pass data value to next PX job parameter?
Hi, I am looking for a way to pass ouput value out of a PX job to be used as value in parameter of another PX job. Job 1 Row Generate -> Transformer((CurrentTimestamp())) -> Sequentail File (Seq.txt) Output "2013-11-18 13:13:50" Job 2 DataSets -> Transformer -> Oracle I have an UPDATE_TM f...
- Wed Nov 13, 2013 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash partition doubt
- Replies: 3
- Views: 1222
Thanks for the reply. We are not suppposed to use Auto partition. Copy stage I should keep partition, cannot leave to Auto. If i keep the Hash in copy stage, i should be carry forwarding the same partition forward. Tools -> DataManagement -> Check no. of records in node 1 and node 2. Is this the met...
- Wed Nov 13, 2013 10:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash partition doubt
- Replies: 3
- Views: 1222
Hash partition doubt
Hi, I have a job. OC connector -> copy -> DataSet. Eg. I have done the hash partition of 3 key columns in copy stage and same partition has been kept in Dataset. How do I make sure the hash partition on those keys which I have done is correct or not ? Jobs are running in 2 nodes. Any help would be a...
- Wed Nov 13, 2013 9:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varbinary datatype in source
- Replies: 2
- Views: 1815
- Wed Nov 13, 2013 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DFLOAT into column SFLOAT issue
- Replies: 10
- Views: 10830