CODEWITHSUNDEEP
datastage
Subhasree Mitra
Subhasree Mitra

Reputation: 65

Datastage Scenario Based Requirement

Requirement

i/p

abc 1 1234 null

abc 1 null 4561

o/p

abc 1 1234 4561

How to do it using Datastage?

Upvotes: 0

Views: 133

Answers (1)

MichaelTiefenbacher
MichaelTiefenbacher

Reputation: 4005

Based on the very basic information from your query I suggest trying an Aggregator stage but it could also be solved with a transformer.

The first two columns seem to be the key columns and use max for all the other ones in the aggregator.

Upvotes: 1

Related Questions