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.?
953
Explain and compare etl & manual development?
Is apache nifi an etl tool?
how do u really know that paging to disk is happening while u are using a lookup transform?
Compare etl & elt?
SCD2 will work on only dimension tables as well as fact Table?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
List few etl bugs?
What is full load & incremental or refresh load?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is tracing level?
what is the use of server?
What is data cleaning?
What is data modeling and data mining?
Identifying the bottlenecks in various components of Informatica and resolving them.