IICS| reading multiple flat files and write into target table
Use Case : Read multiple files with similar structure/data from source flat file and write into target Oracle database.
Design/Implementation:
Source : empData.txt - consists of list of file name
for eg. DEPT_10.CSV, DEPT_20.CSV and DEPT_30.CSV
above physical file present same folder.
Source Qualifier property : source type defined as file list and point empData.txt
Expression transformation : convert string hiredate info from source into to_date(hiredate,'yyyy-mm-dd hh24:mi')
Target : T_EMP (Oracle database).
