Email this page to a friend
Bookmark us
FAQs
Search :
Concepts
1. What is a Data warehouse?
2. What is a Data mart?
3. What are the various approaches of building a Data warehouse?
4. What is OLAP?
5. What is ETL?
6. What is the Difference between OLTP and OLAP?
7. What are the various Reporting tools in the Market?
8.What is Metadata?
9. What is Staging Area?
10. What is Factless Fact Table?
11. What is slowly changing dimension?
12. What is a Surrogate key?
13. What is a Data source?
14. What is Virtual Data Warehousing?
15. What is the difference between star schema and snowflake schema?
16. What is Data Profiling?
17. What is a Junk Dimension?
18. What is a Fact table?
19. What is a Dimension table?
20. What is fact constellation?
21. What is cube?
22. What is drill-down and drill-up?
23. What is the need of building a data warehouse?
24. What is Data Modeling? What are the different types of Data Modeling?
25. What are the different types of Data models?
26. What are the different types of OLAP TECHNOLOGY?
27. What is the difference between a Database and a Datawarehouse?
28. What is a conformed dimension?
29. What is drill through?
30. What is aggregation?
31. What are non-additive facts?
32. What is Data cleaning?
33. What is data migration?
34. What is a legacy system?
35. What is Data Quality Assurance?
36. What is Data transformation?
37. What is Decision support system (DSS)?
38. What is Normalization?
39. What is Hierarchy?
40. What is a Hyper Cube?
41. What is Logical extraction?
42. What is Partitioning?
43. What is Granularity?
44. What are Normal Forms?
45. What is Denormalization?
46. What are the methods of loading data in Dimension tables?
47. What is the difference between core dimension and conformed dimension?
48. What are dimensional attributes?
50. What is logical model?
51. What is physical model?
53. What is modeling?
54. What is business data?
57. What is Data tracking?
58. What is DATA BASE?
59. What is Atomic Data?
60. What is Schema?
61. What is a table?
62. What is a data type?
63. What is NULL?
64. What is ‘constraint’ in relational Databases?
65. What are triggers?
66. Which modeling do we use in Data Warehouse?
67. What is DBMS?
68. What are different types of data mart?
69. What is Connection string?
70. What is Candidate key?
71. What is the different types of modeling?
72. What are the different types of business modeling?
73. What is meant by Business Process Management?
74. What is the need for Business Process Management?
75. What is meta-data text repository?
76. What is a transaction?
77. What is Atomic Property in transaction management?
78. What is Concatenation?
79. What is a computed column?
80. What is the use of cursor?
Cognos
1. What is the BI tool from Cognos?
2. What are the components of Cognos Reportnet?
3. What is Cognos Connection?
4. What is the Reportnet equivalent in latest version of Cognos 8?
5. What is Cognos Data manager?
6. What happened to Power play?
7. What is the difference between Consumer and Recipient?
8. What is the difference between Query Studio and Report Studio?
9. How do we utilise Java Script within Cognos?
10. What is a Prompt?
11. How many prompts are available in Cognos Report Studio?
12. What is Generated prompt?
13. What is a catalog in Data Manager?
14. Which is the scorecarding tool of Cognos 8 BI?
15. What is conditional block?
16. What is cascading prompt?
17. What is the use of connection in Data Manager?
18. What is the purpose of creating dimension builds in Data Manager?
19. What is query calculation in Report Studio?
20. What is the purpose of SQLTerm in Data Manager?
21. What do you mean by DataStream in Data Manager?
22. What is a build?
23. What is a namespace in Framework Manager?
24. Why should we publish a package in Framework Manager?
25. What is a Query Item?
26. What is a Query Subject?
27. What is MDX?
29. What does the Content Manager do?
30. What is Report Layout?
31. Why do we need object-based security in Framework Manager? Where is the feature located?
32. How is Object Security different from Data Security?
33. How to import tables in relational database into Framework Manager project?
34. What is a governor and how do you set it?
35. What is Explorer tab?
36. What is the diagram tab?
37. What is dimension map tab?
38. What is the properties pane?
39. What is the summary pane?
40. What are macros?
41. What are data retrieval limits?
42. Expand BLOBS?
43. When do ambiguous relationships occur?
44. Which are the most common ambiguous relationships?
45. What is the use of ‘object security’ in Framework Manager?
46. What is bursting report?
47. What is a package?
49. What is report specification?
50. What is a regular dimension?
51. What is the use of “_business key” role?
52. What is the use of scope relationship?
53. What are determinants?
54. What is native sql?
55. How do we improve the speed of retrieval of data when running a report?
56. How do we reuse the Cached data?
57. What is the use of governors?
58. What are the benefits of nested packages?
59. What are the methods available to externalize query subjects in framework manager?
60. What is a materialized view?
61. What is a template?
62. How job streams are useful?
63. What is a fact build?
64. What are IQD files?
65. What is the difference between regular dimension and measure dimension?
66. What is the benefit of using portal tabs?
67. What is a job?
68. What is a deployment archive?
69. What is a model?
70. What is a portlet?
71. What are isolation levels?
72. Mention the isolation levels.
73. How are “roles” different from “groups”?
74. What are the uses of trusted credential?
75. What is the full form of XSS?
76. How do we improve the speed of retrieval of data when running a report?
77. How do we reuse the Cached data?
78. What is the use of governors?
79. What are the benefits of nested packages?
80. What are the methods available to externalize query subjects in framework manager?
81. What are the different types of security in framework manager?
82. What are the files that are created when a Framework Manager project is created?
84. What is synchronization in framework manager?
85.When the synchronization is useful in framework manager?
86. What is meant by Dual Display?
87. What is meant by Levels?
88. When are Reporter Report used in Power Play Transformer?
89. Explain the use of Explorer Reports.
90. What is the use of Graph Reports?
SQL Server
1. What is the ETL component of SQL Server 2005?
2. What is the Reporting component of SQL Server 2005?
3. What is the OLAP component of SQL Server 2005?
4. Which version on SQL Server 2005 is required to get all BI functionalities?
5. What is Query parameter in SSRS?
6. What is Report parameter?
7. What is Cascading parameter?
8. What are the Reporting Service Components in SSRS?
9. What is RDL?
10. What is a matrix in SSRS?
11. What is a cache in SSRS?
12. What is report snapshot in SSRS?
13. What is bookmark link in SSRS?
14. What is Command parameter in SSRS?
15. What do we mean by dataflow in SSIS?
16. What is the use of Bulk Insert Task in SSIS?
17. What is Conditional Split transformation in SSIS?
18. What is the use of Percentage Sampling transformation in SSIS?
19. What is the use of Term Extraction transformation in SSIS?
20. What is the use of Asynchronous transformations?
21. What is Data Viewer and what are the different types of Data Viewers in SSIS?
22. What is Ignore Failure option in SSIS?
23. Which are the different types of Control Flow components in SSIS?
24. What are containers? What are the different types of containers in SSIS?
25. What is Format parameter in SSRS?
26. What is Snapshot parameter in SSRS?
27. What are the rendering extensions of SSRS?
28. What is a ReportItem in SSRS?
29. What is Datasets in SSRS?
30. Which tool is commonly used to create queries and execute them against SQL Server databases?
31. Name a few objects that can be included in a logical database.
32. What are the major components involved in processing a SQL statement received from a SQL Server client?
33. What two roles does Microsoft Search play in supporting SQL Server?
34. In which window in Query Analyzer can we enter and execute Transact-SQL statements?
35. What are the three types of Transact-SQL statements that SQL Server supports?
36. Which Transact-SQL element is an object in batches and scripts that can hold a data value?
37. Which Transact-SQL statements do we use to create, modify and delete a user-defined function?
38. What are control-of-flow language elements?
39. Which tool in Query Analyzer enables us to control and monitor the execution of stored procedures?
40. What type of Transact-SQL statement is the CREATE TABLE statement?
41. What is XML?
42. What language is commonly used to work with data in a database?
43. What type of information is displayed on the Execution Plan tab, the Trace tab, and the Statistics tab?
44. What are the differences among batches, stored procedures and triggers?
45. What are the different types of Data flow components in SSIS?
46. What are the different types of data sources available in SSIS?
47. What is SSIS Designer?
48. What is Control Flow tab?
49. What is Data Flow tab?
50. What is the function of control flow tab in SSIS?
51. What is the function of Event handlers tab in SSIS?
52. What is the function of Package explorer tab in SSIS?
53. What is the function of connection managers?
54. What is work offline option?
55. What are Rowset Transformations?
56. What is Solution Explorer?
57. What is Conditional Split Transformation?
58. How do we convert datatype in SSIS?
59. What is the difference between Multicast and Conditional Split Transformation?
60. How is Copy Column transformation useful?
61. What is the use of Export transformation?
62. How Fuzzy Lookup transformation works?
63. What is Character Map transformation?
64. What is Term Extraction transformation?
65. How is setting check points useful?
66. How are variables useful in ssis package?
67. Name the types of variables that can be defined.
68. What is the function of the “Notify operator task”?
69. What is the function of “shrink database task”?
70. What is perspective?
71. What is the need to define perspective?
72. What is translation?
73. How are translations useful?
74. Define mining structures.
75. What is EIS in SSAS?
76. Which type of report class is often used by executives and strategic decision makers in SSAS?
77. What is attribute hierarchy in SSAS?
78. Which are the four main special features to support financial analysis in SQL Server Analysis Services?
79. What is Cube Metadata in SSAS?
80. What is the use of data-driven description in SSRS?
81. What is scripting in SSRS?
82. Why is the ‘main’ method used by script in SSRS?
83. What is the use of pie charts in SSRS?
84. What is the advantage of doughnut chart over pie chart in SSRS?
85. What is proactive caching in SSAS?
86. Which are the two techniques to avoid double counting in SSAS?
87. Which are the three physical storage options available in SSAS?
88. How can user avoid loading the same values into a MOLAP multiple times?
89. What is an MDX script in SSAS?
90. What is the function of query scope in SSAS?
91. Which scope is considered to be highest scope in SSAS?
92. Why is query scope considered to be the lowest scope?
93. What is ‘lull’ in SSAS?
94. How Analysis Services 2005 uses memory during processing in SSAS?
Informatica
1. What is the use of tracing levels in transformation?
2. What are the various types of transformation?
3. What is the difference between active transformation and passive transformation?
4. What is the use of control break statements?
5. What are the types of loading in Informatica?
6. What is the difference between source qualifier transformation and application source qualifier transformation?
7. How do we create primary key only on odd numbers?
8. What is authenticator?
9. What is the use of auxiliary mapping?
10. What is a mapplet?
11. Which ETL tool is more preferable Informatica or Data Stage and why?
12. What is worklet?
13. What is workflow?
14. What is session?
15. Why do we need SQL overrides in Lookup transformations?
16. What is Target Update override?
17. How are Informatica object files stored?
18. How do we tune the performance of Informatica transformations?
19. In what conditions we cannot use Joiner transformation?
20. If there is no PK or FK in the target table, how do we update or insert value into the table?
21. What is the difference between reusable transformation and mapplet?
22. What is the incapability of Lookup transformation?
23. Where do we override native SQL in transformations?
24. When we read from source and write into flat file, how to specify the column names in the flat file?
25. How do we track rejected or bad data?
26. How do we join two tables without joiner or SQL override?
27. What are pre-session and post-session options?
28. How do we copy mapping?
29. What are the tasks done by informatica server?
30. What is the difference between source qualifier and joiner transformation?
31. What are mapping parameters and mapping variables?
32. What is the default join that source qualifier provides?
33. What is Normalizer transformation?
34. What are the default sources supported by Informatica Powermart?
35. What is sql override in Informatica?
36. What is Power Analyzer in Informatica?
37. What are command lines?
38. What is “infacmd”?
39. What is pushdown optimization?
40. What is the function of purging?
41. What are session parameters?
42. What caches are created for lookup transformation?
43. What is the function of Data Cache of lookup transformation?
44. What is the function of index Cache of lookup transformation?
45. What are the different ways to configure the pushdown optimization?
46. What information is displayed in the Gantt chart?
47. What is the function of Rank Transformation?
48. What is the function of Normalizer Transformation?
49. What is the use of Router Transformation?
50. What is the function of Aggregator Transformation?
51. How do we improve session performance while using a shared storage directory for flat files?
52. What is the latest version of informatica?
53. Who is the founder of informatica?
54. What are the features of informatica 8.5?
55. What is informatica power center?
56. What is Informatica power exchange?
57. What is Informatica Data Quality?
58. What is Informatica Complex Data Exchange?
59. What is unstructured data?
60. Give examples of semi structured data format.
61. Give examples of complex structured data format.
62. What are the types of loading in Informatica?
63. What is normal loading?
64. What is Bulk loading?
65. How are Informatica object files stored?
66. What is active transformation?
67. Can I copy a mapping in Informatica?
68. I want to revert to my previous mapping without affecting the rest of my work. Can I do it and How?
69. What is the use of having breakpoints in a debugger?
70. How can I view the levels in my cube or dimension?
71. I am unable to delete a link between a fact and dimension table in workspace. Why and how can I fix this?
72. What type of repositories can be created using Informatica Repository Manager?
73. What is aggregator transformation?
74. What is Incremental Aggregation?
75. How Union Transformation is used?
76. Can two flat files be joined with Joiner Transformation?
77. What are the types of lookup Caches?
78. What is Hash table in Informatica?
79. What are the scheduling options to run a session?
80. What is Load Manager?
Data Mining
1. What is Data Mining?
2. What are the applications of Data Mining?
3. What is the difference between Statistics and Data Mining?
4. What are some of the popular Data Mining Software's?
5. What is CRISP DM?
6. What are the phases in CRISP DM Process Model?
7. On what kind of data can data mining be applied?
8. What are the various catagories of data mining?
9. What is Text Mining?
Oracle
1. What is OWB?
2. What role does Oracle Enterprise Manager play in OWB?
3. How many Versions of Oracle are available and which is the latest one?
4. Can OWB 9.2 be used in access with Oracle 10g database?
5. What do oracle 9i (i) and 10g (g) stand for?
6. What is Common Warehouse Metadata?
7. What role does Mapping play in Oracle?
8. What is Materialized view in Oracle?
9. What is parallel execution in Oracle?
10. What is the difference between Oracle Discoverer and Oracle Express?
11. What are Cascade Snapshot and No Cascade Snapshot in Oracle?
12. What is Delimiters in Oracle?
13. What is Signature and what is the significance of Signature snapshot in Oracle?
14. What is an Integrator in Oracle?
15. What is Bound Object in Oracle?
16. What is the use of Bridge in Oracle Warehouse Builder?
17. Does Warehouse Builder support parallel inserts, updates, deletes?
18. Does Warehouse Builder handle changes to information in the sources?
19. Does Warehouse Builder support ASCII and EBCDIC?
20. How can SAP data be used as a source with Warehouse Builder?
21. Does the Warehouse Builder SAP Integrator support ABAP code generation?
22. Does Warehouse Builder support extraction from XML sources?
23. What are external tables and does Warehouse Builder support them?
24. What are Advanced Queues and does Warehouse Builder support them?
25. What are table functions and does Warehouse Builder support them?
26. Does Warehouse Builder support non-Oracle databases or flat files as targets?
27. Does Warehouse Builder integrate with external schedulers?
28. Does Warehouse Builder automatically populate a business area for Discoverer?
29. Does Warehouse Builder support 3rd normal form targets?
30. Does Warehouse Builder provide summary support?
31. Is Warehouse Builder capable of storing table space information with database objects?
32. Does Warehouse Builder ensure referential integrity in the warehouse?
33. Does Warehouse Builder support incremental design and can it add changes to an already loaded warehouse?
34. What language does the OWB generate to extract data from sources?
35. What features does Warehouse Builder provide for the runtime environment management?
36. Does OWB provide the ability to select/filter data by row/column during extraction?
37. Which are the components that can be used to define data movements in OWB?
38. What is the need to do validations?
39. What is the collections folder in the navigation tree?
40. What is process flows folder in the navigation tree?
41. What is the public transformations folder in navigation tree?
42. What is the fastest way to load data from a flat file?
43. What is a data rule?
44. How do we tune mapping in OWB?
45. Describe mappings in OWB?
46. Describe the code generated by mapping in OWB?
47. What are the types of transformations in OWB?
48. What are Predefined transformations?
49. What types of custom transformations are there in OWB?
50. What is the OLAP tool for Oracle OWB?
51. What general precautions do we take while mapping in OWB?
52. What is flashback in OWB?
53. What is the use of collection?
54. What is the daily build?
55. What is a smoke test?
56. What is runtime view?
57. What is the Data Quality Operator?
58. What is a value-based hierarchy?
59. What is Data Profiling?
60. What are the methods to transform data in OWB?
61. How do operators transform data?
62. What are the benefits of oracle partitioning?
63. What are the benefits of OWB?
64. What is Oracle designer?
65. What is code generator?
66. What is Collection?
67. What are the uses of Oracle Discoverer Viewer?
68. What is Materialized view?
69. What is a Connector?
70. What is the purpose of Check constraint?
71. What are mappings?
72. What are the types of operators available in mapping editor?
73. What is the function of Deduplicator operator?
74. What is the function of Metadata Loader?
75. What is a bridge?
76. What are design time repository and runtime repository?
77. What is SQL*Loader?
Business Objects
1. What is Broadcast Agent?
2. What is Web Intelligence?
3. What is a Universe?
4. What kind of analysis is provided in BO?
5. What is an Object?
6. What is a class?
7. Which tool is provided in BO for data modeling?
8. Which tool is used for reporting in BO?
10. How can we check the universe?
11. What are universe parameters?
12. What are the types of universes in Business Objects?
13. What is security domain in BO?
14. What are alerters in BO?