How does one handle denormalized data with kettle?

I had a similar problem with denormalization. I had an etc/group file with a structure like group:gid:member1,member2 and I denormalized it with a User Defined Java Class component, so finally I have fields group,gid,member I know you need the other direction, but it may be a good starting point for you. Here is the source: public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException { // boilerplate Object r = getRow(); if (r == null) { setOutputDone(); return false; } if(first) first = false; String tmp = get(Fields.In, "members").

GetString(r); if(null==tmp) return true; String accounts = tmp. Split(","); for(int i=0; iLength; ++i){ Object out_row = RowDataUtil. AllocateRowData(data.outputRowMeta.size()); for (int j=0; jOut, "account").

SetValue(out_row,account); putRow(data. OutputRowMeta, out_row); } return true; }.

I had a similar problem with denormalization. I had an /etc/group file with a structure like group:gid:member1,member2,...., and I denormalized it with a User Defined Java Class component, so finally I have fields group,gid,member. I know you need the other direction, but it may be a good starting point for you.

Here is the source: public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException { // boilerplate Object r = getRow(); if (r == null) { setOutputDone(); return false; } if(first) first = false; String tmp = get(Fields. In, "members"). GetString(r); if(null==tmp) return true; String accounts = tmp.

Split(","); for(int i=0; iLength; ++j) out_rowj = rj; String account = accountsi; get(Fields. Out, "account"). SetValue(out_row,account); putRow(data.

OutputRowMeta, out_row); } return true; }.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.