DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sainath



Group memberships:
Premium Members

Joined: 19 Nov 2004
Posts: 125

Points: 1133

Post Posted: Sun Apr 16, 2017 5:10 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 53877
Location: Sydney, Australia
Points: 292373

Post Posted: Sun Apr 16, 2017 6:20 pm Reply with quote    Back to top    

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 p ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
sainath



Group memberships:
Premium Members

Joined: 19 Nov 2004
Posts: 125

Points: 1133

Post Posted: Sun Apr 16, 2017 7:19 pm Reply with quote    Back to top    

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
Rate this response:  
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2519
Location: USA
Points: 18171

Post Posted: Mon Apr 17, 2017 7:34 am Reply with quote    Back to top    

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
Rate this response:  
sainath



Group memberships:
Premium Members

Joined: 19 Nov 2004
Posts: 125

Points: 1133

Post Posted: Mon Apr 17, 2017 10:13 am Reply with quote    Back to top    

Hi
I am thinking quality stage or visual manual
Inspectiion
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 53877
Location: Sydney, Australia
Points: 292373

Post Posted: Mon Apr 17, 2017 5:52 pm Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours