Informatica Basic Interview Questions
- What do you mean by Enterprise data warehouse?
- What is ETL (Extract, transform, Load) and write some ETL tools.
- What is Informatica PowerCenter?
- Name different types of transformation that are important?
- Write the difference between connected lookup and unconnected lookup.
How many repositories can be created in Informatica?
We can create any no. of repositories in Informatica Under one server i.e. only one global repository. You can install one Repository Server on a Windows machine.
How are license keys obtained for Informatica products?
Informatica generates a license key based on the product and product options that your organization purchased. The license key controls the application services and the functionality that you can use. When you install the Informatica services, you must enter the path and file name of the Informatica license key.
What are the 3 types of SCD?
What are Slowly Changing Dimensions
| SCD Type | Summary |
|---|---|
| Type 1 | Overwrite the changes |
| Type 2 | History will be added as a new row. |
| Type 3 | History will be added as a new column. |
| Type 4 | A new dimension will be added |
What is surrogate key in Informatica?
Surrogate key is a substitution for the natural primary key. Data warehouses typically use a surrogate, (also known as artificial or identity key), key for the dimension tables primary keys. They can use Infa sequence generator, or Oracle sequence, or SQL Server Identity values for the surrogate key.
How many interview icons are there?
Download 366 free Interview Icons in iOS, Windows, Material, and other design styles. Get free Interview icons in iOS, Material, Windows and other design styles for web, mobile, and graphic design projects.
Where to get the icons of Informatica components?
1. From where to get the ICONs of Informatica components You can see the icons in following path. Informatica\\9.1.0\\clients\\PowerCenterClient\\client\\MappingTemplate. For this you need Microsoft visio installed on your system.
Where can I find free icons for my project?
Open Peeps – Busts illustratio We help you find free icons for your web projects, apps, magazines, posters, advertising designs or any other purpose… You can download them in png format, ico, icns or svg.
