What are the new features of Informatica 9.x in developer level ?
- From a developer's perspective, some of the new features in Informatica 9.x are as follows:
- Now Lookup can be configured as an active transformation - it can return multiple rows on successful match
- Now you can write SQL override on un-cached lookup also. Previously you could do it only on cached lookup
- You can control the size of your session log. In a real-time environment you can control the session log file size or time
- Database deadlock resilience feature - this will ensure that your session does not immediately fail if it encounters any database deadlock, it will now retry the operation again. You can configure number of retry attempts.
What are ETL Tools ?
ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse for decision making. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database.
What are Dimensional table ?
Dimension tables contain attributes that describe fact records in the fact table.
What is data Modeling ?
- Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database. Data Modeling consists of various types like :
- Conceptual data modeling
- Logical data modeling
- Physical data modeling
- Enterprise data modeling
- Relation data modeling
- Dimensional data modeling.
What is Surrogate key ?
Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table.
What is Data Mining ?
A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information.
What is Operational Data Store ?
A ODS is an operational data store which comes as a second layer in a data warehouse architecture. It has got the characteristics of both OLTP and DSS systems.
What is the Difference between OLTP and OLAP ?
OLTP is nothing but Online Transaction Processing which contains a normalized tables.
But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.
How many types of dimensions are available in Informatica ?
There are three types of dimensions available are :
- Junk dimension
- Degenerative Dimension
- Conformed Dimension
What is Difference between ER Modeling and Dimensional Modeling ?
- ER Modeling is used for normalizing the OLTP database design.
- Dimensional modeling is used for de-normalizing the ROLAP / MOLAP design.
What is the maplet ?
Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mappings.
What is Operational Data Store ?
A ODS is an operational data store which comes as a second layer in a data warehouse architecture. It has got the characteristics of both OLTP and DSS systems.
What is the Difference between OLTP and OLAP ?
OLTP is nothing but Online Transaction Processing which contains a normalized tables.
But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.
No comments:
Post a Comment