I want to create a mapping in Informatica Powercenter for the following functionality :
Initial Target Table Values : Field 1 : 100, Field 2 : 200, Field 3 : 300, Field 4 : 400.
Now, if the record is updated with a new value, say 500... then field 1 value should be moved to field 2.. and field 2 to field 3... and field 3 to field 4... and the new value should be inserted in field 1. so the output would be :
Field 1 : 500, Field 2 : 100, Field 3 : 200, Field 4 : 300.
How can I achieve above functionality?!
