Here you can find Informatica Interview Questions and Answers.
In this Informatica Interview Questions and Answers section you can learn and practice Informatica Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Informatica interview.
AllIndiaExams provides you lots Informatica Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Informatica Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Informatica Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Informatica technical interview.
What is Data warehouse?
In 1980, 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". A Data ware house is a relational Database Management System which is specifically design for Business analysis and making decisions to achieve the business goal. A data ware house is design to support decision system(dss). It is also called historical database. Because it will keep all the historical information. It is also called as Read only database system.
What is the difference between database and data warehouse?
A database is a collection of related data. A data warehouse is also a collection of information as well as a supporting system.
What are the benefits of data warehousing?
Historical information for comparative and competitive analysis. Enhanced data quality and completeness. Supplementing disaster recovery plans with another data back up source.
What is EDW?
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization. this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department. Advantages of having a EDW: 1. Golbal view of the Data 2. Same point of source of data for all the users acroos the organization. 3. able to perform consistent analysis on a single Data Warehouse. to over come is the time it takes to develop and also the management that is required to build a centralised database.
What is the Difference between static cache and dynamic cache?
Static cache: We can not insert or update the cache. Dynamic cache: We can insert rows into the cache as we pass to the target.
Explain What is batch and describe about types of batches?
Batch--- is a group of any thing Different batches ----Different groups of different things. There are two types of batches 1. Concurrent 2. Sequential
Explain What is the limit to the number of sources and targets you can have in a mapping?
As per my knowledge there is no such restriction to use this number of sources or targets inside a mapping. Question is " if you make N number of tables to participate at a time in processing what is the position of your database. I organization point of view it is never encouraged to use N number of tables at a time, It reduces database and informatica server performance
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session. Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches : Sequential - Run Session One after the Other. Concurrent - Run Session At The Same Time.
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
What are the reusable transforamtions?
Reusable transformations can be used in multiple mappings. When you need to incorporate this transformation into maping, U add an instance of it to maping. Later if you change the definition of the transformation ,all instances of it inherit the changes. Since the instance of reusable transforamation is a pointer to that transforamtion, You can change the transforamation in the transformation developer,its instances automatically reflect these changes. This feature can save you great deal of work. A reusable Transformation is a reusable metadata object , defined with business logic using single Transformation.