48

Following query gives details of all locks. SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID


17

The following script can be used in order quickly identify all lock objects within your Oracle system. select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine from v$locked_object a , v$session b, dba_objects c where b.sid = a.session_id and a.object_id = c.object_id; Reference:-...


13

UPDATE: for a more generic example of creating and populating a calendar or dimension table, see this tip: Creating a date dimension or calendar table in SQL Server For the specific question at hand, here's my attempt. I will update this with the magic you use to determine things like Fiscal_MonthNumber and Fiscal_MonthName, because right now they're the ...


11

Does this mean Microsoft will eventually try to deprecate SSRS? Ref: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/ No. We moved Reporting Services installation from the SQL Server installer to a separate installer. This is a packaging change, not a product change; access ...


7

About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, ...


4

Even if we generate a precomputed table with all of the columns in it (example: 80 columns, 300K rows), performing analysis on this is slow [...] Since we do not know ahead of time which fields would be queried on the most, we cannot put indexes on specific columns. On the other hand, (correct me) I don't believe it's best to place 80 indexes on a table. ...


4

This is commonly represented with an accumulating snapshot fact table or timestamped accumulating snapshot fact table. Accumulating snapshot tables model events in progress for business processes that involve a predefined series of steps. The timestamped. You'll have a date key in the table that represents the date the opportunity hit each stage. If you ...


4

Checking whether the dates are contiguous You don't say which DBMS you're using here, but you're using SSAS so I'm guessing SQL Server. If you're on a recent enough version, using LAG and LEAD in window functions can be really handy for this kind of task. You can order the rows by the start date or by an incremental ID if you have one, and then use these to ...


4

Evaluation Edition is Enterprise Edition with a timebomb (180 days). It includes SSIS, SSAS, SSRS, etc. So you can evaluate that for 180 days to learn the ins and outs of BI. Developer Edition, also, provides these tools for ~$50-60 (Microsoft sells it direct for $59.95, though you may find it cheaper from other retailers). The difference is no timebomb but ...


4

With hot_standby_feedback on, vacuum can still be done, but it will be less effective as some tuples that would otherwise be vacuumed now have to be delayed to a later vacuum. The only real downside that I know of is the increased bloat. How much of a downside this is depends entirely on your usage. The worst case is if your database has small, intensively ...


4

The secondaries can be used as read only. Keep in mind data is still being added to the secondaries in near real time. Transaction log backups are conducted against the primary AG instance. If the secondary can not keep up with the volume of transactions coming across, it can cause the transaction logs on the primary to fill and continue to grow. In the ...


4

1.Does Always On Availability Groups mean the database will basically be mirrored and that I can use that server to offload the heavy reporting to? It'll be a full copy of the database. You can think of it as mirrored but it's not really the same thing. 2.Does that break point in time transaction logs backup of the prod server? No. 3.Can this cause a ...


3

In response to your reply to my comment, I mentioned some of the areas in which PostgreSQL shines for DW work - notably CTEs (Common Table Expressions - AKA the WITH clause) and Window functions (AKA the OVER clause). Without these in MySQL, you'll end up writing your own hacks to emulate these (and, no disrespect, but it'll take a while for your code to be ...


3

So after messing with this off and on for a while I figured it out. It is possible. All this was done on one server with SharePoint 2013 enterprise and SQL Server 2012 Enterprise with SP2. I have a default SQL server instance with all features selected, specifically the shared features "Reporting Services - Sharepoint" and "Reporting Services Add-in for ...


3

I'd use the same dimension table. Especially for a date dimension This is a Role Playing Dimension also here I would not let a client tool (or an Oracle forum post!) determine my SQL Server DW design.


3

I just completed a 4 day course with the Kimball group and they had this to say on naming conventions: Always use full descriptive names ie. Brand Name. and don't use abbreviations. Otherwise you may need to spend time training users. Don't use Dim or Fact in your table names because you end up spending a lot of time deleting these from the reporting layer....


3

Almost always surrogate keys (your "Auto Incrementing primary key") are best in data warehouses. I have seen very few exceptions where this is not the case (but some do exist) - yours does not seem to be exceptional. To answer why would be repeating stuff you can find all around the web, by the giants in the field, for instance: http://www.kimballgroup.com/...


3

From your screenshot I judge that you are using the Express installer (It says: Select the express features to install), SSDT and Visual Studio 2010 have no influence on the options in this installer. Make sure you install the Microsoft SQL Server2008 R2 RTM - Express with Advanced Services as that is the only one including BIDS. Have a look at Features ...


3

SSIS is going to execute outside of SQL Server's address space. The data flow transformation within SSIS derives its performance through in-memory transformation to data. The more ram you can give it, the better theoretical performance you can obtain. All things being equal between servers, I'd be surprised if there was an appreciable difference no ...


3

I know this is an old question, but I want to throw this out there in case anyone else happens upon this post. Create a "scripts" folder in your SQL Database Project, and add a Pre-Deploy script that will create the temporary table in Oracle; right click on the script and set the Build Action to PreDeploy. I know it's not the most elegant solution, but it'...


3

Ok, based on your very limited documentation, I would do the following: Fact Tables - Your fact table is your measurement table. It is the thing that happened. It is the meeting together of dimension tables, typically at a point in time. In your diagram, RESPONSES is your fact table. OPTIONS could be a fact table. If you denormalize it you could have ...


3

What parameters are You use for Talend tMySQLOutput? What MySQL settings? It could not be faster then INFILE, but still really depend from settings. You can post Your question on TelndForge forum with screen short of Job components, will try to help For example one of my regular Talend-MySQL Jobs (billing prepare) - transfer from->to mysql 2M of records, ...


3

ELT is fine for a critical system. Your problem is predicated on this faulty assumption: "Because the data is not cleaned up like in ETL..." You can do most any cleanup with ELT as you do with ETL. You just generally do it in a staging table on the target system instead of in-flight between the source and target. Edit: You asked why do they mention: ...


3

No, you wouldn't update the fact table. The fact record is tied to the version of the customer which existed between 2018-04-02 11:52:47.040 and 2018-04-02 22:29:05.243 in which they had a 1.99 tppessoa If they generated a 3.1 tppessoa at 2018-04-03 00:00:00.000 then your fact table would look something like idFact idcipessoa tppessoa ------- -------...


3

No. What you describe are all variants of ELT. The difference between ETL and ELT is in where you do the "T". The "traditional" ETL flow would implement the "T" (data transformation) outside the DBMS, using a specialized tool like DataStage, Informatica, Talend, etc. The data transformed to the target model would then be simply ...


2

If at all possible, I would allocate the shipping cost to line items. This would let you assess the actual cost and profit for individual products as accurately as possible. If this is not possible, I second @Jamie's idea of making Shipping a special type of "product." This is discussed by Kimball in The Data Warehouse Toolkit (third edition), page 185, ...


2

You can query the currently locked objects from V$LOCKED_OBJECT. There is no history for the locks though, logging all the locks would case huge performance overhead and a lot of data to be stored. The closest that the database has is Active Session history V$ACTIVE_SESSION_HISTORY, DBA_HIST_ACTIVE_SESS_HISTORY (if you have the proper license to use it), ...


2

In very very layman terms, business intelligence essentially means analyzing and interpreting data for business purposes. Business intelligence turns extremely raw data into valuable information that businesses can use to make strategic decisions. Different types of businesses can use BI in many different ways to improve operations. Among the industries that ...


2

Using the below query you can find out locks on the table. column oracle_username format a15; column os_user_name format a15; column object_name format a37; column object_type format a37; select a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from (select object_id, SESSION_ID, ...


2

My answer is a big YES - you should store business logic in data warehouse. That is one of the ideas of data warehouses in the first place. If you have tens of reports showing or filtering leads imagine if a rule to qualify someone as lead would change. Also, what if you have to access DWH data with different tools/systems - you'd need to replicate all the ...


Only top voted, non community-wiki answers of a minimum length are eligible