Etl logic

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Etl logic

Post by sainath »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Post by sainath »

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
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

How do you know which description is correct?
Choose a job you love, and you will never have to work a day in your life. - Confucius
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Post by sainath »

Hi
I am thinking quality stage or visual manual
Inspectiion
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How would QualityStage know which is correct? (What is the rule?)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply