Normalize a field on Parallel EXTENDER PX
Posted: Wed Jul 27, 2005 10:40 am
Hello,
I was wondering if anyone know or perhaps provide some solution to the following?
I need normalize each row on a field. I know we can do it with hashed file bu i'm developping on parallel job.
source :
TABLE1 (ID_COUNTRY, LANGUAGE) --> the column LANGUAGE is very variable from NULL to 400 sites
row1 --> [1, "US, FR, IT, GR"]
row2 --> [2, "GR, BG"]
my objectif :
TABLE2 is (ID_COUNTRY, LANGUAGE)
[1, "US"]
[1, "FR"]
[1, "IT"]
[1, "GR"]
[2, "GR"]
[124, "BG"]
I work with DSv7.5.1 EE, AIX 5.2 and ORACLE 921
Thanks in advance
I was wondering if anyone know or perhaps provide some solution to the following?
I need normalize each row on a field. I know we can do it with hashed file bu i'm developping on parallel job.
source :
TABLE1 (ID_COUNTRY, LANGUAGE) --> the column LANGUAGE is very variable from NULL to 400 sites
row1 --> [1, "US, FR, IT, GR"]
row2 --> [2, "GR, BG"]
my objectif :
TABLE2 is (ID_COUNTRY, LANGUAGE)
[1, "US"]
[1, "FR"]
[1, "IT"]
[1, "GR"]
[2, "GR"]
[124, "BG"]
I work with DSv7.5.1 EE, AIX 5.2 and ORACLE 921
Thanks in advance