DSXchange

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

Thanks for the reply.

We are changing the target datatype to Varchar(8)

Thanks,

Thanks for the time and replies. @srinivas.g set is AL32UTF8. @Andy, Hex value for ? is 3F inputlink.Integer = svVarChar ->Varchar(8) Right(("00000000":svVarChar),8) = svChar -> Char(8) Iam getting the below values. 00123456 00654321 00000001 But again when I want to remove the leading &qu...

Thanks,

This job already has a variable APT_STRING_PADCHAR with value 0x20.

But when I run the job by making
CHAR(8) to varCHAR(8)

jobs runs fine.

Is it because of length giving this issue?

Thanks,

Thanks for the reply.

The column is being directly mapped in transformer from
Col_1(Integer) to Col_1(Char(8)) its eight

Thanks,

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

Thanks, will try and get back,

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

Thanks for the replies.

Thank you for the reply.

We are not using sequence in our jobs, we are having other scheduler.

Any other options.

Thanks,

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

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

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

Thanks for the reply.

Source column was dropped, we did not carry this forward.

Thanks,

Thanks for the reply.

Sorted out the issue, no need of any conversation, when we load to Oracle, the values are getting matched.

Thanks,