-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
-
-
What is the functionality of Lookup Transformation
(connected & un connected)
-
-
-
-
-
-
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
-
What is Informatica Metadata and where is it stored?
Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations during the ETL process. The Informatica Metadata is stored in Informatica.
-
What is ETL
ETL is extraction,transformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary transformations done in between.