DSXchange

Got some resolutions from DBA.We need to work on SQL queerys.Need to filter the data more and need to create an index some coulmns.....thanks to all

we have same jobs on two diffrent prodution environment.All jobs are same there is no diffrence on jobs. in one production with 50K data job has finishedsuccessfully..aprox..15 mints In other production with 50K data job has taking nearly 1 hr.evry thing is same on both env jobs. Please help me on t...

Hi guys, i have a problem with compiling the squence job.When i try to compile the it's giving below error .can any one help me to resolve this problem. JOb Activity-->Job activity : : : Routine activity error is Compiling: Source = 'RT_BP1960/JOB.877802012.DT.1631335856', Object = 'RT_BP1960.O/JOB....

sory t/g datatype is 30,10

Hi, Hi Experts, Source column is datatype is decimal(30,10) and o/p column datatype is decimal(30,1). When i run the iob iam geting below errors pls help me to solve 'APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the dest...

I have increased ,but still error is going on

Decimal (10) but ,Ihave given this somany days ago at that time thre is no errors are there yesturday onwonds only error is giving.

Yes Creig one field having NUMBER rather than NUMBER(15) in my database

ok,Thank you very much for yours concerns. Iwill check with my DBA

one field having datatype in oracle 2 but data is 88 can it fit ?

ok, actualy this error is not showing in perticuler field.I haved cheked data is not lager than datatype

Stil iam facing same problem. I did what ever you have mentioned.
pls give me reply.

how can i open thet previous thread pls tell me .I don't no how

sorry i don't know ,how to open previous thread

still iam facing same problem. I did same thing what u mention please solve my problem.