While interviewing for data warehousing jobs, you may be asked questions about Informatica concepts as well as Informatica-based scenarios. Here are the most commonly-asked Informatica interview questions and answers that will help you ace your upcoming interview. These Informatica interview questions for freshers and experienced are suitable for professionals at any level. For your convenience, we have divided this list of 100+ Informatica questions into 3 sections:
Informatica Interview Questions for Experienced
What are different lookup caches? …
What is the difference between static and dynamic cache? …
What is pmcmd command? …
What do you mean by mapplet in Informatica? …
What is the difference between Router and Filter? …
Follow the steps to generate SCD Type 1 mapping in Informatica
In the database, create source and dimension tables
Create or import source definition in the mapping designer tool’s source analyzer
Import the Target Definition from Warehouse designer or Target designer
Create a new mapping from the mapping designer tab
Drag and drop the source
Select Create option from toolbar’s Transformation section
Select Lookup Transformation
Enter the name and click on create
From the window, select Student dimension table and click OK
Edit lkp transformation
Add a new port In_Student_Id from the properties tab
Connect the port to source qualifier transformation’ Student_Id port
From the lkp transformation’s condition tab, enter the Lookup condition as Student_Id = IN_Student_Id
Click OK
Now, connect source qualifier transformation’s student_id port to lkp transformation’s In_Student_Id port
Create expression transformation using the input port as Stud_Key, Name, Location, Src_Name, Src_Location
Create an output port as New_Flag, Changes_Flag
In the expression transformation’s output ports, enter the below-mentioned expression
New_Flag = IIF(ISNULL(Stud_Key),1,0)
Connect lkp transformation port to expression transformation port
Also, connect source qualifier transformation port to expression transformation port
Form a filter transformation and move the ports of source qualifier transformation
Edit the filter transformation and set new Filter Condition as New_Flag=1 from the edit filter transformation option
Press OK
Create an update strategy transformation
Connect all filter transformation port just exclude except the New_Flag port
From the properties tab of update strategy, enter DD_INSERT as the strategy expression
Drag target definition to mapping
Connect relevant ports to target definition from update strategy
Create a sequence generator transformation
Connect NEXTVAL port to target surrogate key port (stud_key)
Create a different filter transformation
In the filter transformation, drag lkp transformation’s port (Stud_Key), source qualifier transformation (Name, Location), expression transformation (changed_flag) ports
Go to the properties tab to edit the filter transformation
Mention the filter condition as Changed_Flag=1
Click OK
Create the update strategy
Connect parts of filter transformation to update strategy
From the update strategy properties tab, enter expressions DD_Update
In this mapping, drag target definition
From the update strategy, connect all the appropriate ports to target definition
Explore the concept of Business Analytics
Q94. What to do when you get the below error?
AA_10000 Normalizer Transformation: Initialization Error: [Cannot match AASid with BBTid.]
Ans. Follow the below process –
Remove all the unconnected input ports to the normalizer transformation
If OCCURS is present, check that the number of input ports is equal to the number of OCCURS
21. What do you mean by OLAP?
OLAP or also known as On-Line Analytical Processing is the method with the assistance of which multi-dimensional analysis occurs.
