Microstrategy Interview Questions - part 4

76. How long does it take to get Microstrategy Desktop up and running?
Microstrategy Desktop installs in minutes and automatically presents a list of available Microstrategy Intelligence Servers. Within an hour, the installation and setup are completed.

Microstrategy Interview Questions - part 2

  1. Wat is pass thru function?
  2. How to create prompt in prompt filter or cascading filter?
  3. Diff between star and snowflake?
  4. Wat schema does mstr support?
  5. Wat is a true key?
  6. Adv of using fact id on count functions?
  7. Why do we need update schema?
  8. Thresholds?
  9. Diff between simple and compound metric?
  10. how does the ordering change affect the calculation?
  11. Tpes of cache?

Microstrategy Interview Questions - part 1

  1. What is a Command manager?
  2. What is an Object manager?
  3. In the RDF documents, a metric pops up when you run it, how to delete it(there are three ways to delete it)?
  4. Installation of MSTR?
  5. Configuration?
  6. In a document how to repeat a section?
  7. Query builder?
  8. Report wizard?
  9. Report builder?
  10. Configuring data mart?
  11. Fact level extension?
  12. Diff types of reports?
  13. Types of objects?

DataStage Interview Questions and Answers,Solution and Explanation - Part 14

What are the Environmental variables in Datastage?

How do you check for Job Errors in Datastage

What are Stage Variables, Derivations and Constants?

What is Pipeline Parallelism?

Which version of Datastage did you use and what are the features in it?

Why do we use a transformer?

What are different schemas you have used in your project ?

What was the intention of choosing one schema over another ?

DataStage Interview Questions and Answers,Solution and Explanation - Part 13

What is the difference between IBM Web Sphere Datastage 7.5 (Enterprise Edition ) & Standard Ascential?

How do you remove duplicates in dataset

What is the difference between Job Control and Job Sequence

What is the max size of Data set stage?

How do you measure performance in sort stage

How to develop the SCD using LOOKUP stage?

What are the errors you experienced with data stage

DataStage Interview Questions and Answers,Solution and Explanation - Part 12

How do we create index in Datasatge?

What is the flow of loading data into fact & dimensional tables?

What is a sequential file that has single input link?

What is hashing algorithm?

What is Orchestrate options in generic stage, what are the option names. value ? Name of an Orchestrate operator to call.

How do you fix the error "OCI has fetched truncated data" in Datastage

DataStage Interview Questions and Answers,Solution and Explanation - Part 11

Data Warehouse Interview Questions,Live DataStage Tool Interview Questions.

What are Static Hash files and Dynamic Hash files?

What is the difference between Datastage Server jobs and Datastage Parallel jobs?

What is ' insert for update ' in Datastage

What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?

DataStage Interview Questions and Answers,Solution and Explanation - Part 10

Overview:Data Warehousing Interview Questions,DataStage Interview Questions asked in HCL,Wipro,TCS,Infosys,Tech Mahindra,Patni,Sasken,Birlasoft

What is iconv and oconv functions?

What is project life cycle and how do you implement it?

For what purpose is the Stage Variable is mainly used?

Explain the purpose of using the key and difference between Surrogate keys and natural key

DataStage Interview Questions and Answers,Solution and Explanation - Part 9

How to drop the index before loading data in target and how to rebuild it in Datastage?

How can ETL excel file to Datamart?

What is the transaction size and array size in OCI stage?how these can be used?

What is job control? How it is developed? Explain with steps?

What is the purpose of exception activity in Datastage 7.5?

Other than Round Robin, What is the algorithm used in link collecter? Also Explain How it will works?

Recent content