Lets say I use the SpoolDir Source connector for disgesting a CSV files. This SCV file has a field named EventTime. This field is formatted as yyyy-MM-dd HH:mm:ss.
Is it possible to use either a SMT or something else to break this field up in 2 (e.g. Date & Time) and populate these fields using Date part and Time part of the EventTime field?