Irin,

There are several approches to your problem. If you give some sample records
of the two tables, suitable solutions can be suggested.

Muthia Kachirayan


On 4/10/07, Irin later <irinfigvam@yahoo.com> wrote:
>
> I need to merge two tables. One of them is very huge one in Data warehouse
> Data mart.
>
> My understanding is that before merging the tables I must sort them first
> by a common key.
> Is there any way to do merging without sorting a huge view of the table?
> OR how to implement a code?
>
> Thank you in advance,
>
> Irin
>
>
> ---------------------------------
> Be a PS3 game guru.
> Get your game face on with the latest PS3 news and previews at Yahoo!
> Games.
>