I have a scenario to implement which is as follows:
There is one folder which consists of three files (a.csv, b.csv and c.csv).
Now based on the names of the files i want to dump them into a Database like : a.csv into table A, b.csv into table B and c.csv into table C.
How should I iterate over the files and dump them iteratively. Please attach some screenshot of the job design if anyone has a solution to this.
Thanks in Advance