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
Etl logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: