DSXchange

Hi Im having trouble with decimal multiplication. I have a source field (Col1 datatype in oracle is Number) and one more field thats(col2 datatype in oracle is Number). here is a sample: Col1=386.48 Col2=0.27225701061802341410291315001361285053 (no rounding is allowed) Now if i do this calculation i...

Hi Craig

I changed the values in the DSParam file and now Im able to see the logs in the director. Thanks.

Hi

Until yesterday, everything was OK, and I was able to see the job logs. I tried to login to the IBM Information Server Web console, but dont remember making any changes. Why did this happen.

Hi I checked the DSParam file and I see this: RTLogging=0 ORLogging=1 Should I change this to RTLogging=1 ORLogging=0 One more question, when I opened the DSParam file I made a copy and then opened it with wordpad, so can I directly edit or make changes and new file in place, will this affect the ex...

Hi I'm trying to view the job logs in DS Director and i'm not able view any logs. I tried to search the forum and found results only for DS on a UNIX machine and not for windows. From other postings I see that I need to change / check the values for RTLogging and ORLogging, but i'm not sure where to...

Read the source (im considering your source is a delimited text file) file in one column, using a sequential file stage, then use a transformer and use fiel function to seperate it to different fields, or you can also use a Column import stage.

How about having two jobs?

When you set stable sort to true the input (non key column) sort order is maintained, when you set it to false the sort order is not maintained. basically its used to maintain the order of Non key columns.

Did you try LongVarBinary?

you can use the StringTodate function in the transformer

StringToDate(Column_name,"%dd-%mm-%yyyy")

Hi First if you want to restart the sequence from where it aborted, as mentioned previously you need to know where it failed, ie the point of failure. so try to get this information first. In my system, what we do is all the job activity will have a number and we have a seperate file where we store ...

Hi I assue the following: RowNumber -varchar Model - varchar Custnum - integer state varchar2(2) to convert all null model to '02' you can use a modify stage: MODEL_NEW=HANDLE_NULL(MODEL, '02') or if you think that the input is very less and you have a transformer, you can convert all the 00 to 02 a...

Yeah i tried in Oracle, and the entire run time was only 5.02 minutes. thanks criag.

The oracle stage has a simple select query.

Hi I have the following data: Loan_Id Amount Produts_Id Store_Id 1 1000.9 55 12 1 .082 55 12 2 2000 55 32 3 0.8776 55 05 2 9.8 55 32 3 1000 55 05 the total number of records is 28.4 million. No Of Nodes: 2 stages used: oracle---->agg (group by loan_id, product_id, store_id, sum(amount) partition was...