In a scenario , we are going to recieve a flat file which will contains header , footer and data. We have to have to load data in Oracle tables and remove header and footer.
once the data load is complete , we have to delete flat file from source directory.
Please help me in solving this issue.
You have a header parameter in the file datastore. You can provide any number to skip rows from top of the file. For footer you can create a filter in staging area.
Filter coould be something like this.
where source_alias.source_column not like '%FOOTER_OR_ANY_VALUE_AS_PER_YOUR_REQ'
1. open your model (source)
2. go to files
3. set 1 under heading(Number of lines).
you may skip your header by doing this.
for footer you may follow Bhabani's solution as i haven't need ever.
your problem wil get solved.