Fractional Truncation Error from Oracle
Posted: Mon Oct 18, 2004 12:13 am
Hi All,
we have been doing 'day 1 startup' testing where we have been running full volumes of data through DS....one thing we noticed was the /dstage directory where we installed DS is getting used up rapidly....we traced the problem to fractional truncations where we accept a field which is 'number' and move it to number(38) (which means 38,0) and there are SOME numbers on the input tables that have decimal places........we are in a country where the local currency has no decimal places but SOME transactions are in USD....
Problem is, the rows with fractions are spread across the input data. We just didn't see the fractions before because they were buried down the tables quite a bit. We are finding it hard to find the specific columns with the decimal places....
My question is, is there any function in DS that will tell us how many rows or approximate size of a log generated by a particular job? If we can identify the jobs with sizable logs we can then run 10,000 rows and see if we can find the columns with decimal places so we can change them in the target.....
Thanks
we have been doing 'day 1 startup' testing where we have been running full volumes of data through DS....one thing we noticed was the /dstage directory where we installed DS is getting used up rapidly....we traced the problem to fractional truncations where we accept a field which is 'number' and move it to number(38) (which means 38,0) and there are SOME numbers on the input tables that have decimal places........we are in a country where the local currency has no decimal places but SOME transactions are in USD....
Problem is, the rows with fractions are spread across the input data. We just didn't see the fractions before because they were buried down the tables quite a bit. We are finding it hard to find the specific columns with the decimal places....
My question is, is there any function in DS that will tell us how many rows or approximate size of a log generated by a particular job? If we can identify the jobs with sizable logs we can then run 10,000 rows and see if we can find the columns with decimal places so we can change them in the target.....
Thanks