DSXchange

Hi,

How can we implement normalization in our jobs.
Thanks
Sunitha

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.

HI,

in parallel jobs

Thanks
sunitha

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.