DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
esivaprasad
Participant



Joined: 09 Dec 2008
Posts: 135

Points: 1422

Post Posted: Fri Apr 06, 2018 1:26 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi ,

Datastage version=8.1.0.0
We have reconciliations job.
1 source file - extracting data using ECC stage .
2 source file - other team drop the file in datastage server.
we have many reconciliation jobs.
one of reconciliation job had issue.
record value is same in both sources , but still reconciliation not happening.

i applied trim , then tried with TrimLeadingTrailing and then tried with
TrimLeadingTrailing(Convert(Char(10):Char(13):Char(9),' '.
But still recocilation logic not working .

When i see record value is same in both sources.
Please help me

_________________
Siva
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42617
Location: Denver, CO
Points: 219422

Post Posted: Fri Apr 06, 2018 9:06 am Reply with quote    Back to top    

Unfortunately, there's really not enough information for anyone here to provide cogent help. Never mind I had to look up what the "ECC stage" might be, seems to be related to sourcing from SAP via a 'pack', yes?

Regardless, either your sources (which are not posted here) aren't quite as 'same' as you think they are or your reconciliation logic (which is not posted here) isn't working. Making a wild assumption that it is the same logic the other working reconciliation jobs are using then I'm go with file data being 'not the same'.

Details, please.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54248
Location: Sydney, Australia
Points: 294235

Post Posted: Fri Apr 06, 2018 7:48 pm Reply with quote    Back to top    

When you say the records are the same, we're assuming that you mean visibly the same. But what about non-printing characters? Have you checked for these, for example using a hex editor?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
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