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.?
900
What is the difference between Data Warehousing and Data Mining?
can be used COM component in Informatica ?
When do we analyze the tables? How do we do it?
what is dynamic insert?
How to fine tune mappings?
How many steps etl contains explain with example?
Explain etl mapping sheets?
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 would u estimate the size of Aggregator transform data and index cache?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
how do u implement configuration management in Informatica?
What is data modeling and data mining?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what happens if the info.server doesn't find the session parameter in the parameter file?