Job reads sequential file and load into RDBMS table.
What happen if sequential file has extra column in the back of each record?
It depends on data type of last column defined by DS and RDBMS table.
- If data type of last column = varchar, extra column will be included as last column.
- If data type of last column = numeric, last column value will become 0 because there is delimiter character which usually not a numeric.
- If data type of last column = date, extra column will be dropped.
Their result base on transformer stage behavior on implicit data type conversion.
1 comment:
Simple and easy to retrieve reports is a critical functionality required in data analytic tools. Organizations are facing challenges in integrating the BI systems with the existing system and generate reports that offer actionable insights. Visit https://www.inetsoft.com/
Post a Comment