Explain the difference between etl tool and olap tools?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

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.

3 Answers   TCS,


What is a staging area? What is the purpose of a staging area?

0 Answers  


how do u automate Extraction process?

1 Answers  


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.?

0 Answers  


What is full load & incremental or refresh load?

0 Answers  


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?

1 Answers  


When do we analyze the tables? How do we do it?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


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

0 Answers  


Explain and compare etl & manual development?

0 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


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??

4 Answers  


Categories