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??
Concatenating Whole Records in one column for all records.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: