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.?
how many maximum session supports to multiload in teradata ??
What are various etl tools in the market?
What are the steps involved in etl process?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the three tiers in etl?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
What is data cleaning?
what are business components in Informatica?
what are the data modeling tools you have used?(polaris)
What is lookup table in etl testing?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what are the facilities provided by data warehouse to analytical users?