let me explain my work flow it may help in a better way.
I have a set of calldetails which is coming to my system unix file area which needs to be lookup with the incoming phone numbers and replace a perticular value in the call details file and then use our core api to calculate the rate of call and upload to our database.
So my intension is to do the lookup before the call rates are getting calculated.since my sore api which calculates the rate can only identify input as flat file,so i have to get the file as flat file after this lookup.
So how can i bring database in b/w these?
that y i thought of a perl script which can do the lookup activity whose performance is comparable with database.
But since this perl is very new to me..i am really confused and am not getting any encouraging reply from this site also....
I have alreadt done this logic with sql loader and shell scripting ,but im not quite satisfied with the performance.That y i turned to perl.....