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.?
494
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?
Explain about etl data integration software?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the use of server?
Mention few test cases and explain them?
What are cubes and olap cubes?
Can there be sub steps of etl steps?
Explain do we need an etl tool?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are dimensions?
What do you understand by active and passive transformations?
how would u estimate the size of Aggregator transform data and index cache?
what is an ETL or ETT? And what are the different types?
when will use SQL override in a lookup transformation?