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.?
947
What are the key benefits of ETL Testing?
Explain etl?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the etl testing operations includes?
What is a lookup table in etl?
what are the facilities provided by data warehouse to analytical users?
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain the key challenges that you face while performing etl testing.
What do you understand by the term ‘transformation’?
How can we use external procedural logic in informatica?
SCD2 will work on only dimension tables as well as fact Table?
In Which Transformation We Can Use Having Clause In Informatica?
what is an ETL or ETT? And what are the different types?
where are the log files generally stored.Can you change the path of the file.what can the path be?