I want to transform ms sql database table to postgres through a transformation. In this transformation, I want to add a new column which contains uuid for the new row to be inserted. As well as uuid should be generated from the table contents itself. I can transform the table (without uuid) for now..but unable to generate uuid and map it to the postgres database table. Can I map it through tMap??
I added column for storing "uuid" in target table. And I have my own mechanism (breaking 1 column of same table into pieces and re arranging it) to generate through SELECT sql (using queries in repository). What does that query returns as result set?? How to see that? I am giving the output of the query to a tMap component. But the result of that query can not be read by tMap. How to resolve this issue? tMap is forwardly connected to target DB (Postgres).