DSXchange

Hi, I have a vaue for one of the fields which is coming in as 'abcdef&ghijkl' instead of 'abcdef&ghijkl' the problem is it is not coming at the fixed place. I need to replace that "&amp" with "&" in that string. Please help me if anybody has idea on using a right ...

Hi All,

when I run the ETL I am getting the below warning. Can anybody help me
why am I getting this warning.


APT_CombinedOperatorController(1),0: APT_Decimal::operator=: Source decimal has even precision, but non-zero in leading nybble, or is too large for destination decimal



Thanks

Hi All,

Can someone tell me how to remove the double quote from the first position of the field value as below


"12345678


Thanks

Hi All,

I have a problem of adding '1' to date and populating as a next date.
for the date value coming in as 20091015 I need to add '1' and make it
to 20091016. Do we have any solution for this kind of problem.


Thanks

Hi,

I have a file to process that file has a filename as filename_date.csv
I need to pass that date in the job is there anyway to do this.
If so please let me know.


Thanks

Hi,

If you have huge data which lookup is a better option to choose.
spars or normal lookup and can you please explain me why.


Thanks

Hi


can anybody tell me what this error is

UOWPoolingMultiManager,0: OCI ERROR: ORACLE Error code : 2049
ORA-02049: timeout: distributed transaction waiting for lock
'


thanks

any thoughts??

Hi All- I am having a problem in the Column_Import stage. reading the file writing header and trailer in two different column_import stages in the trailer I am having a field called "A". Actually it is a tab delimeter file. In the trailer column_import the error is getting like below. Copy...