Concatenating Whole Records in one column for all records.

[gnan_gun]

Need to create a PX job for the following requirement

My source data is like
COL1 COL2
AAA 1
AAB 2
AAC 3
AAD 4
... .
... .
... .
10000+ RECORDS
Required Target data should be like
COL1 COL2 COL3
AAA 1 AAA-1,AAB-2,AAC-3,AAD-4,.........10000+
AAB 2 AAB-2,AAA-1,AAC-3,AAD-4,.........10000+
AAC 3 AAC-3,AAA-1,AAB-2,AAD-4,.........10000+
AAD 4 AAD-4,AAA-1,AAB-2,AAC-3,.........10000+
... .
... .
... .
10000+ RECORDS

Here COL3 first 5 characters should Contacatenation of COL1 & COL2 for that respective record.

Which stage/logic(Job design) can achieve this??

[ray.wurlod]

Looks like a full outer self Join to me.