590
社区成员
发帖
与我相关
我的任务
分享分享一个BI的试题，顺便请大牛给点意见
以下是澳洲某个BI公司回复的网上测试题，我以前没接触过SSIS这些东西，对于这份网上试题我也挺好奇我的简历居然通过了。现在既然收到了回复，那就多花点时间研究下SSIS，请大牛们看下，能否给我些答案方向？先谢谢了！
At a high-level, briefly explain how you would efficiently process a dimension using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个维度。
At a high-level, briefly explain how you would efficiently process an SCD using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个SCD。
At a high-level, briefly explain how you would efficiently process into a Fact Table using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个Fact Table。
In your experiences, what are the performance pitfalls of SSIS and what methods do you undertake to workaround them ? (Things to consider are how the data flow pipeline works for bulk inserting, updating, deleting, etc.)
基于您的经验，SSIS有哪些性能缺陷，以及您有什么方法可以避开他们？（考虑大量插入，更新和删除等数据流水线如何工作）
Briefly explain the uses of Alternative Hierarchies.
简单解释下替代层次（Alternative Hierarchies）的使用
Briefly explain the benefits of Calculated Measures.
简单解释下计算的量度（Calculated Measures）的好处。
List all the reporting suites you have experience in (rank by experience)
列出您用过的报告套件（reporting suites）
Briefly explain the types of SCD.
简单解释下SCD的类型
Briefly explain the types of Facts.
简单解释下Fact的类型
Briefly explain the concepts of Dimensional Modelling
简单解释下维度建模法的概念（Dimensional Modelling）。
Briefly explain your testing methodology.
简单解释下您的测试方法。
Do you have experience with Automated Testing tool ?
您有没有用过自动化测试工具，有的话有哪些？
At a high-level, briefly explain how you would efficiently process a dimension using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个维度。
At a high-level, briefly explain how you would efficiently process an SCD using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个SCD。
At a high-level, briefly explain how you would efficiently process into a Fact Table using SQL and SSIS.
从高一点的层次上看，简单解释下您如何有效的使用SQL和SSIS来处理一个Fact Table。
In your experiences, what are the performance pitfalls of SSIS and what methods do you undertake to workaround them ? (Things to consider are how the data flow pipeline works for bulk inserting, updating, deleting, etc.)
基于您的经验，SSIS有哪些性能缺陷，以及您有什么方法可以避开他们？（考虑大量插入，更新和删除等数据流水线如何工作）
Briefly explain the uses of Alternative Hierarchies.
简单解释下替代层次（Alternative Hierarchies）的使用
Briefly explain the benefits of Calculated Measures.
简单解释下计算的量度（Calculated Measures）的好处。
List all the reporting suites you have experience in (rank by experience)
列出您用过的报告套件（reporting suites）
Briefly explain the types of SCD.
简单解释下SCD的类型
Briefly explain the types of Facts.
简单解释下Fact的类型
Briefly explain the concepts of Dimensional Modelling
简单解释下维度建模法的概念（Dimensional Modelling）。
Briefly explain your testing methodology.
简单解释下您的测试方法。
Do you have experience with Automated Testing tool ?
您有没有用过自动化测试工具，有的话有哪些？
...全文
请发表友善的回复…
发表回复
abraham_qu 2013-06-18
- 打赏
- 举报
谢谢分享啊，如果能贴出来答案就更好了 :D
cadoupanpan 2013-06-11
- 打赏
- 举报
SCD has type 0 fixed attribute, type 1 changing attribute and type 2 historical attribute, can google their meaning.
reporting suites can say I used SSRS, quikview, crystal report, and say some of your personal experience.
总的来说，题目很难，很多没有碰到过，谢谢分享。
szp895 2013-06-10
- 打赏
- 举报
好吧 我正在看 除了前三个问题以外应该都能从书上找到 先谢谢了
szp895 2013-06-10
- 打赏
- 举报
谢谢大牛！
Warren 2013-06-09
- 打赏
- 举报
澳洲哪家公司啊，问题问得这么好？
KevinLiu 2013-06-09
- 打赏
- 举报
微软有专门介绍SSIS和SSAS的书籍，里面应该都会有讲解。
KevinLiu 2013-06-09
- 打赏
- 举报
没用过SSIS处理数据加载，不过这些做ETL都会遇到的。
大力水手 2013-06-09
- 打赏
- 举报
这个真不会，看来BI真要好好补补！
唐诗三百首 2013-06-09
- 打赏
- 举报
Do you have experience with Automated Testing tool ?
您有没有用过自动化测试工具，有的话有哪些？
--> LoadRunner
