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: 43045
Location: Denver, CO
Points: 222248

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

"May the bridges I burn light my way forward"
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: 54549
Location: Sydney, Australia
Points: 295797

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?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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