Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2010 @ 10:52:52 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: OBIEE - Teradata environment
 
From:   David Pracy

There was a version of OBIEE that ignored the specified joins, inferring Joins based on the positions of the tables in the query section - worth checking for.

Whenever possible we give the OBIEE developers all SQL to run - mainly using Macros and selects from Views - OBIEE is used purely as presentation. There are many benefits of this approach.

Check that the OBIEE developers are actually applying the query predicates in the query that is sent to TD - I have seen essentially Selects * with the filtering done on the local result set.

Whilst the Master Data Model approach has benefits I have seen it lead to queries with multiple extraneous Joins being sent to the db.

I can't remember any specific optimisations regarding setup of OCE's and ODBC but will have a look when Iget to work tomorrow.

The Teradata BI COE may have more specific info on TD OBIEE interaction.


Hope this helps

David Pracy



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019