Explain the difference between etl tool and olap tools?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
What is a staging area? What is the purpose of a staging area?
how do u automate Extraction process?
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.?
What is full load & incremental or refresh load?
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?
When do we analyze the tables? How do we do it?
what are Lookup caches options? Including persistent caches.
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain and compare etl & manual development?
explain the methodology of Data Warehousing?(Polaries)
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??