Concatenating Whole Records in one column for all records.
Posted: Fri Feb 06, 2009 12:09 am
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??
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??