You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Showing only difference when comparing files
#1 2008-09-02 15:22:25
- Orchis65
- Member
- Registered: 2008-08-16
- Posts: 12
Showing only difference when comparing files
Hello,
I'm trying to compare two tables in two different instances of oracle by extracting them into text files and then compare the resulting text files.
My problem is that even if there is only one different row the tFileCompare component shows a message for all row as soon as it detects any difference.
Is there any way to show a message only for the different rows ?
Offline
#2 2008-09-02 15:42:20
- nkxx
- Member
- Registered: 2008-08-05
- Posts: 32
Re: Showing only difference when comparing files
Maybe you should not use this kind of link between the tOracleOutputBulk and the tFileCompare. Try a trigger link "on component ok" or "on subjob ok".
You have plenty of errors because it loops on every row.
For example if your file is like :
1;aaa
2;bbb
3;ccc
4;ddd
It will first compare it to 1;aaa
Then to 1;aaa
2;bbb
Then to 1;aaa
2;bbb
3;ccc
And at last it will do the right comparison
Hope i'm not putting you on the wrong track.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Showing only difference when comparing files