I'm evaluating Talend for a data migration project, and I'm trying to get a simple scenario going. I've got a source database table and a target database table, and I'm trying to map from one to the other. I have imported both tables into my repository as a schema. I have created a tMSSqlInput for one table and a tMSSqlOutput for the other tab, and a tMap. When I create the connection from the input to the tMap, it automatically populates the input schema on the left hand side of the mapping dialog. However, when I create an output connection from the tMap to the output, it doesn't import the output schema into the mapping dialog at all. Is there another way to do this automatically? Or do I have to manually create an output schema in the mapping dialog that matches the schema of the output component?
We have a case when tables in the source in MySQL have a different column set and names than in the destination MySQL. We use tMap to map those columns. The column names on the source are populated nicely from the source, but columns on the destination not and we need to add them manually. Since there are tons of tables and columns to be mapped it can become a nightmare mannual work.
Is there is the way to populate column names on the destination in tMap?
