How to change a composite key?

[viniciusrabelo]

Hi,

I have three tables: A, B and AB and the key of table AB is a composite key of table A and table B.
How can I change an composite key between two tables?

I tried with tMap, but I need to link the key that I want to change, then I can't indicate what key will be the new value...

Thanks a lot

[viniciusrabelo]

I am sending the model to you can see what I want to do...

Thanks

[stasp]

I believe tMap should suit your needs. You'll just need to (manually) change the value of required fields in output table. This can be achieved by adding simple expressions.

You may want to check the JasperETL Guide from the "Docs" section for tMap examples.

 

HTH

Stas P