normalization

sunitha_cts · Post by **sunitha_cts** » Thu Jul 16, 2009 11:33 pm

Hi,

How can we implement normalization in our jobs.
Thanks
Sunitha

ray.wurlod · Post by **ray.wurlod** » Thu Jul 16, 2009 11:37 pm

That question is too vague.

One way would be to construct a server shared container containing a UniVerse stage or Hashed File stage and use the intrinsic dynamic normalization capability of that stage type.

Another way would be to use the Complex Flat File stage. This has the ability to handle OCCURS (repeating groups) in a number of ways, including generating multiple rows (normalization).

You could probably also do something with Promote Subrecord stage; though I haven't investigated this stage type very much.

sunitha_cts · Post by **sunitha_cts** » Thu Jul 16, 2009 11:39 pm

HI,

in parallel jobs

Thanks
sunitha

ray.wurlod · Post by **ray.wurlod** » Thu Jul 16, 2009 11:42 pm

Yes, that's how I answered.

(Actually I think the blocking operation in the server shared container might not be permitted. But everything else I suggested, including the use of server shared container, is perfectly legal for parallel jobs.