Hello,
first many thanks again for the last advice by my Question with the topic
"File with different Data Records". It is very useful, I have tested.
Is the "Balanced Line Compare (-mode)" by comparing of two sorted files (datasets) popular?
Before comparing, the files are sorted by the compare-key. As a compare-result for 2 rows (records) you have 3 cases: keys identical, or key file A <key> key file B (record only in B)….
I thing the term is from cobol and mainframe world.
Are there Clovel ETL element or graph for that?
Thank you,
Peter
first many thanks again for the last advice by my Question with the topic
"File with different Data Records". It is very useful, I have tested.
Is the "Balanced Line Compare (-mode)" by comparing of two sorted files (datasets) popular?
Before comparing, the files are sorted by the compare-key. As a compare-result for 2 rows (records) you have 3 cases: keys identical, or key file A <key> key file B (record only in B)….
I thing the term is from cobol and mainframe world.
Are there Clovel ETL element or graph for that?
Thank you,
Peter
-
Hi, I think you look for DataIntersection component
Please sign in to leave a comment.
Comments 1