 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums iWay Software Product Forum on Focal Point [CLOSED] Datamigrator turns inner join into left outer
Focal Point Forums iWay Software Product Forum on Focal Point [CLOSED] Datamigrator turns inner join into left outer Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Datamigrator turns inner join into left outer | Login/Join |
| Platinum Member |
Hai we have source table A that has to be inner joined with source table B. To be able to join them we have to transform an attribute in table A. Table A has an attribute called IBAN. We have to get the last ten positions of this field of 34 bytes. Because of this transformation of an attribute used in het join, Datamigrator 81M makes a hold file. And the inner join of two tables becomes a left outer join of the hold file of table A with table B. We now solve this problem by excluding the rows with NULL values in table B. But why transforming the inner join to an outer join??? Is there a solution that the inner is not changed to an outer? Thnx RonThis message has been edited. Last edited by: FP Mod Chuck, WebFOCUS AppStudio 8.2.04 WebFocus Datamanagement Console 8.1M DMC | ||
|
| Guru |
I've never seen the behavior you describe where an INNER JOIN becomes an OUTER. Have you tried just changing it back in the Join Editor? If that doesn't work I would suggest opening an InfoResponse case and provide the source synonyms and data flow. That said, assuming your source is relational database tables, instead of doing a source transformation to extract the partial field value, do it in the Join Calculator. Replace the transformed field with a calculation on the original field: SUBSTR(IBAN FROM 24 FOR 10) N/A | |||
|
| Platinum Member |
Thnx for the advice Clif. The input is a table of 2 million records. Putting it in the join calculator means that during join DB2 has to do some work (conversion). It won't like that I presume resulting in a less performance. But we will give it a try one of these days. WebFOCUS AppStudio 8.2.04 WebFocus Datamanagement Console 8.1M DMC | |||
|
| Platinum Member |
Addition: the JOIN editor says INNER JOIN. That isn't changed. But we see in our output that the job behaves like an outer join. WebFOCUS AppStudio 8.2.04 WebFocus Datamanagement Console 8.1M DMC | |||
|
| Virtuoso |
Ronibi I suggest you open a case with techsupport on this issue. It should not behave like an outer join. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums iWay Software Product Forum on Focal Point [CLOSED] Datamigrator turns inner join into left outer
Focal Point Forums iWay Software Product Forum on Focal Point [CLOSED] Datamigrator turns inner join into left outerCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |