DSXchange

Hi Phani,

I have tried this looping but could not achieve the desired result. Could you please explain me in detail what needs to be Done.

Thanks in Advance

Hi Team,

I have below requirement,please suggest approach to get desired output
input:
2
3
4
1
output:
2
2
3
3
3
4
4
4
4
1

Output should get the multiple values based on the value of input field.

Hi Team,
I am using below conversion in one of the derivation in Transformation stage:
DateToDecimal(Column_name,"%yyyy%mm%dd")

Which is throwing below warning:
Conversion error calling conversion routine decimal_from_date data may have been lost.

Please help to avoid above warning

Hi Team, I have Type 1 table,where in new records will be inserted and if matching record foound it should update existing record. So in target oracle connector enabled RCP and the write mode is Update then insert ,but throwing below error. The connector could not automatically generate the WHERE cl...

Also in source oracle connector stage datatype is Decimal [38][10].

but i doubt if we give derivation alias name and column in source stage with different names, it may through error.
MyColumn - MyNewColumn

Please elaborate.

Thanks for instant reply,
Target column datatype: Decimal [38] [10]
Its not one to one mapping,doing some calculation in between.

changed length as per target size and tried removing abs() function.
but still facing error.

Hi Team, Derivation for one of the column in my oracle connector is as follows: AVG( NVL(C1, 0) ) * AVG( CASE WHEN C2 <= 0 THEN ABS(C2) ELSE 0 END ) When i run job,getting below error message: While reading data for column COLUMN_NAME, the connector received Oracle error code ORA-1406. (CC_OraStatem...

Hi ArndW,

After changing it to char,it is working fine.

Thanks.

Hi Team, I am using below below query in oracle connector in my parallel job in order to get yaer and month from date. select to_char(DATE_COLUMN,'YYYYMM') from table_name. While running facing error:literal does not match format string. If i run same query in oracle datbase its working,not sure why...

Hi Team, I have requirement to convert timestamp to varchar.my source field is time stamp and target is varchar field. input:07/18/2013 17:00:00 output:07182013 i'm getting desired ouput,but warnings are coming with error message: conversion error calling conversion routine... i had tried below opti...

Thanks for your inputs..

Hi Team, I have a server routine with below code to get the status of job,i need the same functionality to incorporated in a PX routine.As am not familiar with parllel routine,can any one help me with code. $include DSINCLUDE JOBCONTROL.H JOBHANDLE=DSAttachJob(JOBNAME,DSJ.ERRFATAL) Ans=DSGetJobInfo(...

Hi Team, I need to develop a parallel job to migrate tables from sybase to oracle server. I'm using sybase connector and oracle connector with create target table YES and RCP enabled in job properties. but getting below error in the oracle stage,though enabled RCP The connector could not validate th...