DSXchange

Hi
We have below sample data
Source Code desc
A. ABC Invalid n/a
B ABC Inv n/a
C. ABC. INV n/a

Output

Source. Code. Desc

AorBorC. ABC. Invalid n/a

I want above output record . How to implement
in datastage to get one record also how can I use
Quality stage to get valid correct description

Thks

You've been here long enough to know that we don't like to have to guess at requirements. Please describe the required logic IN WORDS (a design specification, if you will), and then we'll be better placed to understand what you are trying to achieve.

Where would a "valid correct description" come from? (QualityStage does not have a "read my mind" stage, any more than Datastage does.)

Hi
I have requirement where data comes from 3 source system with source system code,

Code and description . You have to load one record with unique code with correct description

How to achieve this in datastage. Also can we
Use quality stage to get correct description
Thks

How do you know which description is correct?

Hi
I am thinking quality stage or visual manual
Inspectiion

How would QualityStage know which is correct? (What is the rule?)