Hi,
I like the idea of a good easy to use data pump product, however there seem to be a few key things that are missing:
- Ability to ignore primary keys on insert for non-nullable rows that have default population values (the current workaround is to modifiy the table or source files)
- Column Mapping - this currently seems very slow, with a file with many column names. This should at least attempt to map 1:1 with CSV/files with header rows matching the same column names as a default option (This is a challenge with source files > 50+ Columns)
- Errors: (not appearing in the warning logs) - the following error '<file>' file importing into '<table> . "source column index for table '<>' is out of source data range' - with status that these allowed continued processing. Not sure why these should not be logged at all. [Replicatable with the PPD_PlanLevel.csv in this public data set: U.S. Public Pensions Data, fiscal years 2001-2016 | Kaggle ] - checked the file does not look like there should be any errors.
Thanks.
