DI Query

[LinusH]

ok. And update A with information from B?

If A is registered in metadata the standard Table Loader should be able to do this.

[Sheeba]

Hi Linush,

Both Table A and B are registered in the metadata.

A                                                                                          B

groupid  element pf                                                      group id element pf

I would like to compare the element and pf of both the tables A and B. if both match, i want to assign A.gorupid= B.group id. If the columns are not matching, I want to assign a new value to A.groupid using surrogate key generator.

Regards,

Sheeba Swaminathan