Only one pushdown per DF in BODI 11.7?

Advertisement
We have a pretty complex ETL process with dozens of DFs that are liberally sprinkled with data_transfer transforms, added by the original developers with the intent of getting SQL to push down to the SQL Server 2005 where the data is stored. According to "display optimized SQL", it appears that most of them are not pushing down. In fact, I built a very simple DF based on sys.objects and sys.columns with one-column query transforms going to data_transfers then to another query transform that combines the two forks by selecting one of the columns that is then pushed to the target table. If I delete either one of the forks the other pushes down with an INSERT a SELECT b FROM c format, but when I have both forks in the DF, only one or the other will push down.
It seems like there is some kind of configuration parameter that is limiting pushdown functionality but I can't figure out what it is. I've read up on things that prevent push-downs, messed with different configs trying to see if anything made a difference, and finally created an ultra-simple DF to demonstrate the problem. I'm out of ideas, and this is killing our performance- our big ETL process is running in 10 hours every day, but if we fixed this it might run in a third of the time.
Thanks for your help.
Advertisement

Replay

Odd. I have no problems viewing all the tracks on an album, whether I'm viewing by album or by artist. And I can't seem to force a situation where I get only a subset and a "next" button. What Mac model are you running, and what screen resolution?
Regards.

Permit only one access per user on guest portal Cisco ISE

Hi, Could you please help me to figure it out if it´s possible to create a guest account on cisco ISE which permit only one concurrent access? We don't want to have multiple devices registering with the same account, just one different account for ea

Only one account per mac

Originally, i'd used my intel macmini with my music match login and everything worked fine. Then i created a new user for my wife and her different music match login on the macmini. Finally, I have tried to setup my 2011, 15" MacPro laptop to be my m

Only one PI per server object!

As the result of a SR for a problem we were having, it appears that oracle lite does not support more than one publication item being created even in different applications/publications for the same server table/view 10.2 only objects if you try to c

Only one computer per account with the new Adobe CC 2014

Hi guys, i have just upgraded all my apps to the brand new CC 2014, which also means everything is doubled in my application list. It all went fine at my work's computer but when I went back home and launched after effects CC 2014, it asked me for a

My iPod only lets me put one album per artist on it, how do I fix that?

I have 42 days worth of music that I am not able to put onto my iPod because my iPod only lets me put one album, per artist onto it. How do I fix that?Connect it to your computer and Restore it in iTunes.Read other 2 answers

Oracle utilizes only one core out of 8 core's.

Dear Team , We have noticed that, in oracle database server Oracle processes uses only one core and that goes to 100% usage remains are at idle possition thats the reason the Oracle performance is very poor some time system haults and needs to be sta

ITunes 90 day lock out on iMac - only one AppleID can use a Mac at any one time?

Just found out, the hard way, about Apple's patently ridiculous "90 Day Lockout" policy on iTunes (Match, Purchases download and pretty much ALL the useful features). Apparently, at least according to Support - who feigned surprise that this was

Hacking application id equals() to allow more than one row per "primary key"

I have a read only entity whose primary key is not the real primary key on the underlying table. The result is that I get more than one row per "primary key". This is what I want. However KODO will not allow me do it, because I am storing the co

Can I have more than one iphone per email account?

When my son got his iphone 4s I used my email address since he didnt have one yet.  I have since gotten an Iphone 4s also, but when I went to activate it I had to put it under another email account, since mine was used for my sons iphone, so I used m

When defining copy rules, only one source field allowed

Our users have requested the facility to allow them to copy pricing condition records when in in VK12 transaction. But when configuring the copy rules, we have come across the following problem: When configuring copying rules for copying pricing cond

PR created by MRP only one item each PR

Hi Gurus, I ran MRP using T-Code MD01. Running succesful. But when I check PR created only had one material each PR, so too many PR Created in the system. The requirement is How can we run MRP then PR created in lot (each PR has many items) ? I've se

Limiting MDB to one instance per cluster

I'm working on a Weblogic setup that has one cluster consisting of three servers. We have one queue in particular whose MDB does a lot of database access. We're running into locking problems with the database because Weblogic is running an instance o

Why does firefox display one word per sentence

firefox displays one word per sentence reading comments on www.zerohedge.com firefox is the only browser that does this Firefox has always done this reformat of the coments since day one why??Can you attach a screenshot? *http://en.wikipedia.org/wiki

CRM ORG is supporting only one sales group to only one sales office,

Hi Users, CRM system is supporting only one sales group to only one  sales office, not supported to multiple sales offices. Per ex : Sales Organization     Distribution Channel     Division        South Sales Office     South Sales Group             

Rating system that limits each user to one vote per item

I am creating a PHP-based website where people can upload content and other users can rate the content. How do I create a rating system that only accepts one vote per registered user for each submission?On 04 Apr 2007 in macromedia.dreamweaver, Angry

Why I cannot enter an "Activity Type" for a trip with only one destination?

Hello experts, Doing a travel expense the user must specify the type of activity (u201CAu201D, u201COu201D or u201CSu201D) that the trip expense is involved, but this option itu2019s only available when the trip has more than one destination (inside

Multiple line item in billing but only one line item in accounting document

Hi Everyone, I am having one scenario in which sales order has more than one line item. Only one billing document is create for all line items in Sales Order but billing document contains as many items as sales order has. In accounting document of bi

Structure inside while should work only one time ?

Hi Everyone ,                   I have coded a program that if i click a button ( switch untill released) . inside that structure should work only one times .                    and i have coded and its working fine .. but its looks compilcated..    

UCCX 8.5.1 SU2 Agent Line/Ext on Two IP Communicators - Only One Will Be Registered

I have a corner case where an agents laptop may use a local Gigabit Ethernet port or a different Gigabit Ethernet port located on a laptop docking station using IP Communicator 8.6(2). Due to a requirement for QM/Compliance Recording (per Calabrio),