Interview Questions.

Q1. What Are The Different Methods Of Loading Dimension Tables?

There are two unique approaches to load data in measurement tables.

Conventional (Slow) : All the limitations and keys are tested in opposition to the data before, it's miles loaded, this manner information integrity is maintained.

Direct (Fast) : All the limitations and keys are disabled earlier than the facts is loaded. Once statistics is loaded, it is confirmed in opposition to all of the constraints and keys. If statistics is found invalid or grimy it isn't always protected in index and all destiny methods are skipped on this records.

Q2. What Are The Different Ways To Migrate From One Environment To Another In Informatica?

We can export repository and import into the new surroundings

We can use informatica deployment organizations

We can Copy folders/objects

We can Export each mapping to xml and import in new surroundings

Q3. What Is Informatica Powercenter?

Powercenter is facts integration software program of Informatica Corporation which presents an environment that allows to load records into a centralized region along with facts warehouse. Data can be extracted from multiple sources may be trformed consistent with the enterprise good judgment and can be loaded into files and relation targets.

Q4. What Is Oltp?

OLTP is abbreviation of On-Line Traction Processing. This system is an utility that modifies facts the instance it receives and has a big variety of concurrent users.

Q5. What Is Dimension Table?

Dimensional desk contains textual attributes of measurements saved within the statistics tables. Dimensional table is a set of hierarchies, categories and common sense which may be used for user to traverse in hierarchy nodes.

Q6. What Is A Mapplet?

AN mapplet is a reusable object that incorporates a hard and fast of trformations and allows to reuse that trformation logic in multiple mappings.

Q7. How To Delete Duplicate Record In Informatica?

Following are methods to cast off reproduction facts

In supply qualifier use select distinct

Use Aggregator and institution by way of all fields

Override SQL query in Source qualifier

Q8. How To Find All Invalid Mappings In A Folder?

Use following question

SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE 

SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED <>1

Q9. What Is Trformation?

A trformation is a repository object that generates, modifies or passes facts. Trformations in a mapping constitute the operations the Integration Service performs at the records. Data passes via trformation ports which are connected in a mapping or mapplet.

Q10. What Is Olap?

OLAP is abbreviation of Online Analytical Processing. This system is an software that collects, manages, procedures and offers multidimensional statistics for analysis and management functions.

Q11. What Is Dimensional Modeling?

Dimensional records model idea entails  forms of tables and it is exceptional from the third ordinary shape. This standards makes use of Facts desk which contains the measurements of the enterprise and Dimension desk which incorporates the context(measurement of calculation) of the measurements.

Q12. What Is Data Warehousing?

A statistics warehouse is the main repository of an business enterprise’s historic statistics, its company reminiscence. It includes the uncooked fabric for control’s choice aid machine. The critical thing leading to the use of a facts warehouse is that a information analyst can carry out complicated queries and evaluation, such as records mining, at the facts with out slowing down the operational systems. Data warehousing series of records designed to help management selection making. Data warehouses contain a huge kind of facts that present a coherent photo of enterprise situations at a single factor in time. It is a repository of integrated data, to be had for queries and analysis.

Q13. Are You Seeing Awareness Trlate Into Bigger Budgets For Mdm?

It’s a matter of awareness and the problem becoming pressing. We are seeing budgets expanded and more fulfillment in closing deals, mainly in the pharmaceutical and monetary services industries. For rester predicts MDM can be $6 billion marketplace via 2010, that is a 60-percentage boom price over the $1 billion MDM marketplace final 12 months. Gartner forecasts that 70 percent of Global 2000 organizations may have a MDM answer via the year 20@These are pretty massive numbers.

Q14. What Is Difference Between Mapping Parameter And Variable?

A Mapping parameter is a static price which you define earlier than jogging the session and it cost remains until the cease of the consultation.Whilst we run the session PowerCenter evaluates the value from the parameter and keeps the identical cost in the course of the session. When the consultation run once more it reads from the file for its cost.

A Mapping variable is dynamic or adjustments every time at some stage in the consultation. PowerCenter reads the initial value of the variable before the start of the consultation and modifications its value with the aid of the use of variable capabilities and earlier than finishing the session its saves the contemporary fee (remaining value held with the aid of the variable). Next time whilst the consultation runs the variable cost is the remaining saved price within the previous session.

Q15. What Are Fundamental Stages Of Data Warehousing?

Offline Operational Databases : Data warehouses in this preliminary stage are developed by way of simply copying the database of an operational system to an off-line server wherein the processing load of reporting does no longer impact at the operational gadget’s performance.

Offline Data Warehouse: Data warehouses on this level of evolution are up to date on a ordinary time cycle (generally day by day, weekly or monthly) from the operational structures and the data is stored in an included reporting-oriented records structure.

Real Time Data Warehouse:Data warehouses at this degree are up to date on a traction or occasion basis, each time an operational device plays a traction (e.G. An order or a transport or a booking and so on.)

Integrated Data Warehouse : Data warehouses at this level are used to generate activity or tractions which are exceeded back into the operational structures to be used inside the each day hobby of the enterprise.

Q16. What Are The Biggest Technical And Management Challenges In Adopting Mdm?

Technical parents frequently have a project in facts governance in selling the venture and getting the funding. Management is searching out return on investment; they want MDM tied to quantifiable advantages that business leaders apprehend, like dollar amounts around ROI.

Q17. What Are Different Type Of Repositories That Can Be Created Using Informatica Repository Manager?

Standalone Repository : A repository which capabilities in my opinion and is unrelated to every other repositories.

Global Repository : This is a centralized repository in a domain. This repository can contain shared objects throughout the repositories in a domain. The gadgets are shared thru global shortcuts.

Local Repository : Local repository is inside a domain . Local repository can connect to a international repository the use of global shortcuts and can use items in it’s shared folders.

Q18. What Is A Mapping?

A mapping is a hard and fast of supply and goal definitions connected by means of trformation gadgets that outline the policies for records trformation. Mappings represent the information glide among sources and targets.

Q19. What Are The Components Of Informatica Powercenter?

Following are the diverse components of Informatica PowerCenter,

PowerCentre Domain

PowerCenter Repository

Administration Console

PowerCenter Client

Repository Service

Integration provider

Web Services Hub

Data Analyzer

Metadata Manager

PowerCenter Repository Reports

Q20. What Is Data Mining?

Data Mining is the system of reading records from one of a kind perspectives and summarizing it into useful statistics.

Q21. What Are The Data Movement Modes In Informatica?

Data movement modes determines how electricity center server handles the character statistics. We choose the facts motion in the informatica server configuration settings. Two types of records motion modes available in informatica.

ASCII mode

Unicode mode

Q22. Describe The Foreign Key Columns In Fact Table And Dimension Table?

Foreign keys of dimension tables are primary keys of entity tables.

Foreign keys of data tables are primary keys of Dimension tables.

Q23. What Is Mdm?

Master statistics management (MDM) is a comprehensive method of enabling an corporation to hyperlink all of its critical information to one report, called a grasp file, that gives a commonplace factor of reference. When properly achieved, MDM streamlines records sharing among personnel and departments.

Q24. What Is Fact Table?

Fact table includes measurements of business methods additionally truth desk incorporates the overseas keys for the dimension tables. For instance, in case your commercial enterprise technique is “paper manufacturing” then “average production of paper by using one system” or “weekly production of paper” would be taken into consideration as size of enterprise manner.