split a column value and create separate rows for each slit
Posted: Wed Nov 02, 2011 4:36 pm
Hi All,
Source is from a SQL Server.
Target is an Oracle table.
I have a requirement where the input is:
Computerid=1,Name="Solaris",Value="CPU1 1156MHz (sparcv9)
CPU2 1156Mhz
.
.
CPU32 1156MHz"
I have to ouput this to:
SurrKey, Computerid=1,Name="Solaris",Value="CPU1 1156MHz (sparcv9)"
SurrKey,Computerid=1,Name="Solaris",Value="CPU2 1156MHz (sparcv9)"
.
.
SurrKey, Computerid=1,Name="Solaris",Value="CPU32 1156MHz (sparcv9)"
Can someone please guide me in the ways this can be built?
I created Surrogate Keys in the transformer stage, after reading the max of surrkey from the Oracle table.Thats one part i have done.
Thanks in advance.
Jay
Source is from a SQL Server.
Target is an Oracle table.
I have a requirement where the input is:
Computerid=1,Name="Solaris",Value="CPU1 1156MHz (sparcv9)
CPU2 1156Mhz
.
.
CPU32 1156MHz"
I have to ouput this to:
SurrKey, Computerid=1,Name="Solaris",Value="CPU1 1156MHz (sparcv9)"
SurrKey,Computerid=1,Name="Solaris",Value="CPU2 1156MHz (sparcv9)"
.
.
SurrKey, Computerid=1,Name="Solaris",Value="CPU32 1156MHz (sparcv9)"
Can someone please guide me in the ways this can be built?
I created Surrogate Keys in the transformer stage, after reading the max of surrkey from the Oracle table.Thats one part i have done.
Thanks in advance.
Jay