Explain do we need an etl tool?
can cubes contain measures ?
what is a worklet?
State the differences between shortcut and reusable transformation
what is the use of structures?how many nodes can u create in a structure?
what is session partitioning?
Explain about enterprise scalability and roi of data integration suite?
Explain what are the various etl tools in the market?
what are the production issues in datastage?
what is pmrep command?
Explain about etl data integration software?
how do use session mapping parameters ?(in which transformation)
Explain and compare etl & manual development?
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.?
where are the log files generally stored.Can you change the path of the file.what can the path be?