Hi,

I am trying to load data from SOURCE to TARGET database. and following below approaches and trying to use hadoop file system but as per my observation Text file system is taking less time to process the data. for both type of file system i am using extension as CSV(coma separated values).

Table Input -> Text file Output then Text file input -> Table output (took 13 sec for 7000 records)
Table Input -> Hadoop file Output then Hadoopfile input -> Table output(took 20 sec for 7000 records)

i know hadoop file system will not be useful for these simple data loading process but looking for best approach. generally hadoop file system should load data fast as compare to text file system, is it correct ?.

but it is not happening in my case

Thank you