Sorry about posting my question twice. After posting it the 1st time I realized that it was in the wrong forum so reposted it in the correct forum and tried to delete it from the wrong one but could not.
We use Sybase IQ, which is a database specifically for data warehousing. The one downside to it is that loading records using an insert SQL statement is agonizingly slow. However, from a flat file and using their proprietary SQL I can load over a million records in seconds. So my plan is to us RapidMiner to create a CSV that I'll then automatically load into the db using Perl or ksh. However, when I create a CSV file RM converts the customer ID to scientific notation. Since no significant digits are lost I can easily convert it back to the actual number, but was wondering if there is a way to have RM keep the actual values.
Here are a couple of lines from the CSV file I created using a decision tree algorithm. Notice that the 2nd to last column, which I'm passing in as an integer ID (107204426 ), now ends in "E8" (1.07204426E8). How do I stop RM from doing this?