Hi
I am getting source in excel file. These files have different fields, while they are mapping to single db table
Example
|
Fields of Source1.xls
|
Fields of Source2.xls
|
Mapping Columns of DB table
|
|
Issue ID
|
Business ID
|
ID
|
|
Issue Name
|
Business Name
|
Name
|
|
Issue Descrition
|
Business Description
|
Descrition
|
Can we make a single configuration file, where all the mapping rule will be defined and a single DTF where loading data from source to database can take place? (if yes, give some sample) Or individual DFT will be the suggested approach?
Appreciate your help on it
Thx in Advance
Shilpa