Cognos Interview Question and Answers

26. What is difference between view and materialized view?
  Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance.
 
Your Name Your Email-ID
Your Answer
27. What is difference between data mart and data warehouse?
 
  • A data mart designed for a particular line of business, such as sales, marketing, or finance.
  • Where as data warehouse is enterprise-wide/organizational
  • The data flow of data warehouse depending on the approach.
 
Your Name Your Email-ID
Your Answer
28. What is DTM?
  DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary.
 
Your Name Your Email-ID
Your Answer
29. What are the different uses of a repository manager?
  Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.
 
Your Name Your Email-ID
Your Answer
30. What are cascading prompts?
  Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt.
 
Your Name Your Email-ID
Your Answer
123456789101112 Page 6 of 12