Topics
Products
Follow Us:

MSBI Questions and Answers (Q&A)

LmAkshay
Answered: Jul 04, 2020
Add a Foreach Loop container to the package.
Add an expression to the Flat File connection manager.
Add a variable to the package.

1 Answer

207 views
LmAkshay
Answered: Jul 04, 2020
Most of the times this is a numeric value
Allows for maintenance of history data (SCD Type 2) when used as a Primary Key
Data coming from multiple source systems can be easily...Read More

1 Answer

204 views
LmAkshay
Answered: Jul 04, 2020
In memory database

1 Answer

204 views
LmAkshay
Answered: Jul 04, 2020
By defining a regular relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table

1 Answer

204 views
Ranaguha
Answered: Jul 04, 2020
ALTER MINING STRUCTURE [Bike Buyer] ADD MINING MODEL [Decision Tree] ( [Customer Key], [Age], [Bike Buyer] PREDICT, [Commute Distance], [Yearly Income] )?USING Microsoft_Decision_Trees WITH...Read More

1 Answer

204 views
LmAkshay
Answered: Jul 04, 2020
PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])

1 Answer

203 views
LmAkshay
Answered: Jul 04, 2020
SharePoint Central Administration
PowerPivot Configuration Tool
. SQL Server Configuration Manager

1 Answer

202 views
LmAkshay
Answered: Jul 04, 2020
Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages

1 Answer

202 views
Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.