I created a project containing a textfile model, a view model (EatsText) which depends on the textfile model. I then stacked another model (UsesText) on top and added a concat sequence to make a fullname. Saved, executed and it looked good.
Then, I refactored EatsTest to Employees and got a validation error in UsesText. When I looked at the transformation, here's what I found:
SELECT
EatsText.et.lastName, Employees.et.firstName, Employees.et.middleName, CONCAT2(EatsText.et.lastName, CONCAT2(', ', CONCAT2(EatsText.et.firstName, CONCAT2(' ', LEFT(EatsText.et.middleName, 1))))) AS FullName, Employees.et.empId, Employees.et.department, Employees.et.annualSalary, Employees.et.title, Employees.et.homePhone, Employees.et.mgrId, Employees.et.street, Employees.et.city, Employees.et.state, Employees.et.ZipCode
FROM
EatsText.et
It has both the old and refactored names in it. Oddly, the SELECT contains both--I could see where the SELECT could be right and the FROM wrong.
- is cloned by
-
TEIIDDES-817 Refactoring a source model left transformation with mix of old and new model names
- Closed