I am getting the following warning at the Transformer stage.
TranEmployee_csv: When checking operator: Data set (Virtual dataset; output of "APT_TransformOperatorImplJob_TranEmployee_csv in TranEmployee_csv"; input to "Oracle_217.inEmployeeSort") has preset schema that differs from the propagated schema. Propagated fields not in existing schema will be dropped; fields in existing schema but not propagated will be defaulted.
It seems that due to this problem the rows are getting rejected. I might be wrong here...
It could be caused by column propagation, especially on fields that you changed the metadata for but not the name. If you couldn't figure out how to address this, just turn off the column propagation for that stage, and see if that shut the log up.
I matched both the schemas and am able to populate the target table , finally (sigh of relief!!!)...But i am still getting the warning of "Mismatched schemas"....Column propagation is set to off...