Sum(1)

[farolito20]

Temp1:

Load

          ID,

Sum(1) as TempId

Resident DimTemporary2

Group By ID;

Drop Field TempId;

Left Join (Temp1)

Load

          ID,

          Rowno()          as TempId

Resident Temp1;

What's the meaning of sum(1)?

[chematos]

That's used as a counter of an ID, so TempId is the counter of ID in this table, but that code is wrong, I think there is no sense on that. That left join is wrong...