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
Explain do we need an etl tool?
how does the server recongnise the source and target databases.Elaborate on this
What do you understand by active and passive transformations?
Explain do we need an etl tool? When do we go for the tools in the market?
Explain the difference between etl tool and olap tools?
Explain about round-robi?
what are Lookup caches options? Including persistent caches.
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.?
What is a lookup table in etl?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what are the concerns of OLTP and DSS systems?
What are the three tiers in etl?
What are the key benefits of ETL Testing?
What is Data Vault???