Automatic transmissions have a clutch that's operated automatically. DSGs have two clutches for quicker gear changes. That's the only major difference.
Virtually all modern automatic transmissions use a "lockup torque converter" for fuel efficiency. The lock-up clutch is activated once the transmission is fully coupled, and at that point the efficiency of the transmission is essentially identical to that of a manual transmission.