What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
How can we use external procedural logic in informatica?
what is data modeling?
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 do use session mapping parameters ?(in which transformation)
what is the advantage of persistent cache? when it should be used?
what is session partitioning?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
Is apache nifi an etl tool?
How etl testing is different from database testing?
Explain different types of partitioning?
what is the meant by Normalization and de-normalization?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?