Answer Posted / ravindra kamble
SMP - Symmetric Multi-Processing
MMP - Massively Parallel Processing
Is This Answer Correct ? | 54 Yes | 14 No |
Post New Answer View All Answers
What is staging area referring to?
What is the difference between Data Warehousing and Data Mining?
how many maximum session supports to multiload in teradata ??
Difference between flat files and relational sources?
What is etl process? How many steps etl contains?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
How many types of transformations supported by sorted input?
How can we use external procedural logic in informatica?
What is tracing level?
what is dynamic insert?
how do u set partition points in the mapping?
How to fine tune mappings?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Explain what is etl process? How many steps etl contains explain with example?