41.What is fact table?
The centralized table in a star schema is called as fact table. Fact tables are three types
additivenon-additivesemi additive
42.What is Data warehouse?
According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.
43.What is Data Transformation Manager(DTM)?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run.
44.How can you define a transformation?
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.
45.What are Lookup transformation?
Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup
definition can be imported either from source or from target tables.
46.What are Source Qualifier transformation?
Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc.
47.What is difference between maplet and reusable transformation?
Maplet consists of set of transformations that is reusable.
A reusable transformation is a single transformation that can be reusable.
48.What are Update Strategy transformation?
Update strategy transformation is an active and connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. You can specify how to treat source rows in table, insert, update, delete or data driven.
49.How many types of dimensions are available in informatica?
There are three types of dimensions.
Star schema Snowflake schema Glaxy schema
50.What is difference between maplet and reusable transformation?
Maplet : one or more transformations. set of transformations that are reusable.
Reusable transformation: only one transformation. Single transformation which is reusable.
The centralized table in a star schema is called as fact table. Fact tables are three types
additivenon-additivesemi additive
42.What is Data warehouse?
According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.
43.What is Data Transformation Manager(DTM)?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run.
44.How can you define a transformation?
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.
45.What are Lookup transformation?
Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup
definition can be imported either from source or from target tables.
46.What are Source Qualifier transformation?
Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc.
47.What is difference between maplet and reusable transformation?
Maplet consists of set of transformations that is reusable.
A reusable transformation is a single transformation that can be reusable.
48.What are Update Strategy transformation?
Update strategy transformation is an active and connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. You can specify how to treat source rows in table, insert, update, delete or data driven.
49.How many types of dimensions are available in informatica?
There are three types of dimensions.
Star schema Snowflake schema Glaxy schema
50.What is difference between maplet and reusable transformation?
Maplet : one or more transformations. set of transformations that are reusable.
Reusable transformation: only one transformation. Single transformation which is reusable.
0 comments:
Post a Comment