Hi,

I'm dealing with web-logs with variable number of fields

Assuming my input file has 100 records, some of those would have 10 fields in a row, some 50 - all delimited by ','.

How do I load such data ? Any pointers please.

Thanks.

Depends entirely upon what all those delimited columns are for.

For example, if the first 5 columns specify the info that identifies the source of the record and all the other columns are groups of 5 each with further info, then you'd presumably have two tables in the DB, each with 6 columns. The first table--the one with the identifying info--would have an added primary key column (probably autoincrement) and then you'd have as many records as needed in the second table, each with a foreign key back to the first table.

But my advice there is just as vague as your question. I don't see how anybody could give a very meaningful answer until you gave some more meaningful data.