Finally I was able to resolve the problem. Apart from different TSV filenames, the other major problem was with the Create Table (products and omniturelogs) commands. It used FIELDS TERMINATED by 't' which is incorrect. The correct expression is FIELDS TERMINATED by '\t' to indicate tab separated value.
Thanks
Anindya