explain the methodology of Data Warehousing?(Polaries)
No Answer is Posted For this Question
Be the First to Post Answer
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 different between sequential batch and concurrent batch and which is recommended and why?
how would u estimate the size of Aggregator transform data and index cache?
can be used COM component in Informatica ?
what is the use of server?
what are the session parameters? How do u set them?
Eliminating of duplicate records without using dynamic lookups
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is the advantage of persistent cache? when it should be used?
what is the use of server manager?
Explain do we need an etl tool?
Can u access a repository created in previous version of Informatica?