How to update tmap after source/target column changes
I have a simple job that moves data from a database table to salesforce via tmap. I modified the source table to add a new column, how do i get tmap to recognize and present the new column? when i retrieve the table changes, it asks to "propagate" the changes, but the newly added column is never added to my tmap. is there a way to refresh the tmap component such that it will see the new columns? this is really frustrating as the only way i have found to work around this is to create a new job and remap everything. there must be an easy way to do this. any help would be greatly appreciated. thanks!!
And the thing that is really the issue for me, is the tmap component. i add columns to the metadata, add columns to the query, but they dont show in tmap. and if i manually add the column to tmap, then use it, i get no data in that column. thanks again!
You need to sort your missing Jar issue. Just click on the Jar icon and search your machine for that Jar. If you cannot find a version of it, then just download it.
However you do not need to do it this way. The reason you are getting nothing is because nothing is being sent from your database component. You might have the column in your SQL but there is no column in the schema for it. In your DB component, go to the "Component" tab and click on the ellipsis button next to "Edit Schema". This will bring up the schema that you DB component is using. You need to add your new column there. It should then ask if you want to propagate your schema (although since you've already created it in you tMap, it may not). Every component (well, most) has a schema that must be set. The SQL query and the schema are not the same thing here.
eureka! so i edited the schema as part of the source and now the new column is available to the tmap. this is exactly what i wanted to do. thanks! now the perfect solution is when i hit propagate, that it would propagate to the componenets and i would not have to do this manually. or even in the schema edit, there was a button to refresh. i had to type the new column in by hand. anyway, this seems to be the solution, not perfect but at least i dont have to recreate the job.
in my job, i am using tELTVertica map, and i see the new columns in my input schema definition but its not reflecting in my TELTmap components. how to propagate the new columns in TELTMap component .
in my job, i am using tELTVertica map, and i see the new columns in my input schema definition but its not reflecting in my TELTmap components. how to propagate the new columns in TELTMap component .
This component uses the tables provided as input, to feed the parameter in the built statement. You have to use tELTVerticaMap along with tELTVerticaInput and tELTVerticaOutput.
