Combining data
In this chapter we discuss stages related to the combination of records. Records can be combined both horizontally and vertically. For horizontal combination (that is, fields values from multiple records from various input links, related through a common key, are combined into a single record image) there are three standard stage types available, Lookup, Join, and Merge. The vertical combination, on the other hand, is represented by the Aggregator stage. Here, multiple records from the same input link are combined and aggregated ...

Get InfoSphere DataStage Parallel Framework Standard Practices now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.