I have got this unusual request here… So I have been trying to join 2 datasources – One is Oracle datasrc(with a volume of 2 M records) and other one is an excel (1 Lac/ 10^5 records)
The excel should be the primary table(left table) and Oracle custom query should be right. Now the resultset always comes up incorrect giving the result of that of the Right join(secondary table).
I tried all possible combinations-
Finally, I pull this excel data into a db table and used the Teradata as the other source for joining and it worked!
Alas my happiness was short lived! …The architects in my team have asked me not to use the workaround(extracting excel data using ETL into DB) strictly.
I need a solution for this , so that once again we can start using excel directly into the data source.
NOTE: Can’t really share the data or the wb here as I am doing it for a client
Is there any chance you could mock up some simplified data similar to the structure that is in both data sources? Can you elaborate a bit on what you mean by "corruption"? It sounds like you're getting unexpected aggregation rather than the file not working as expected.