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.
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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..
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),