DSXchange

Hi

I have a scenario job reading from oracle table and loading into XML file.
in my source i have DAY&NIGHT while writing into traget xml file it is converting into DAY&NIGHT.

for testing purpose if i pass '&' only it is converting into &

thanks

Hi
I am having the sequence with 20 jobs. At the last I want to delete all the Datasets created by the 20 jobs. How to achieve it?

While loading in to the sql server job got abort with the following erroe


ODBC_Enterprise_23,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver]Datetime field overflow

Hi

I have a feild misdate which is indate format,
My requirement is to add a feild (tenure)which is integer to the misdate ie
misdate+tenure

thanks

Hi

My job get aborted and throwing the below as fatal

Transformer,0: Fatal Error: APT_Decimal::assignFromDFloat: the source (Inf) is not a usable floating point value.

hi

I am having date feild named DATE_PURCH
My requirement is DATE_PURCH<>'1900-01-01'
it is ok
and also i have to handel null for it

Hi
I have a feild XX
Wich is of varchar datatype has the values
like
1000007
562369p
12-52-00
1-po-023
90-op-88
I have to take max of it

Thanks

Hi In my requirement I am finding a feild called XXX which is of 24 byte varchar, It is calculated from the column X which is of 1 byte. The logic for XXX Concatenated value of 24 months X with latest month being the 1st byte ie. during very first month run the value in XXX is 0000000000000000000000...

Hi In my requirement I am finding a feild called XXX which is of 24 byte varchar, It is calculated from the column X which is of 1 byte. The logic for XXX Concatenated value of 24 months X with latest month being the 1st byte ie. during very first month run the value in XXX is 0000000000000000000000...

I have month run jobs for my feild XXX for Jan month all the values will be like below while run for every month it should be moved as below the value for feild XXX is from X Month X XXX Jan--0 00000000000 Feb--1 10000000000 Mar--2 21000000000 Apr--3 32100000000 May--4 43210000000 Jun--5 54321000000...

Is Performance is based on Logic or volume of data? In My project I wrote logic for Five different Region in Uat I have one lakh record for all the five region I takes fourty minutes to run the sequence(containing 30 jobs). Now in Production I have only one Region data and the volume is two lakhs, b...

In my sequence While I load into oracle table from ds the job got aborted and the sequence got failed

In Unix box the log has written like below

Record 54626: Rejected - Error on table XXX, column SALARY(decdimal(13,2)).
ORA-01460: unimplemented or unreasonable conversion requested

I am getting warning as "Implicit conversion from source type "dfloat" to result type "decimal[13,2]": Possible range/precision limitation."

Wether it has any impact on data

sorry I want to run from 20th job
I checked Do no Check point run
and in Execution ACTION Reset if required

Hi
In my Job sequence I have 30 job if my job fails at 20th job I want to rerun from 21th job? for this How to use Check point in sequence
Thanks