Based on “The Microsoft Data Warehouse Toolkit” by Joy Mundy and Warren Thornthwaite,
“It may help to think of dimensions as things or objects. A thing such as a product can exist without ever being involved in a business event.”
What’s Data Warehousing
Consider an example where business analyst uses the systems containing operational data (the data that runs the daily transactions of your business). Analysts can use information about, which products were sold in which regions at what time of the year, to look for anomalies or to project future sales. However, there are several problems if analyst accesses operational data directly:
Informatica Designer
The following are some common questions relating to Informatica Designer.
Q. How to execute PL/SQL script from Informatica mapping?
Q. How can you define a transformation? What are different types of transformations available in Informatica?
Q. What is a source qualifier? What is meant by Query Override?
Q. What is aggregator transformation?
Q. What is Incremental Aggregation?
Q. How Union Transformation is used?
Q. Can two flat files be joined with Joiner Transformation?
Q. What is a look up transformation?
Q. Can a lookup be done on Flat Files?
Q. What are Connected and Unconnected Lookups?
Q. What is a mapplet?
Q. What does reusable transformation mean?
Q. What is update strategy and what are the options for update strategy?
