Informatica Job Interview Questions

Informatica Interview Procedure, Informatica Aptitude Questions, Informatica Technical Questions, Informatica Tool Interview Questions

What is the logic will you implement to load data into a fact table from n dimension tables?

What is workflow?

Why you use repository connectivity?

Can you generate reports in Informatcia?

How can we delete duplicate rows from your source in mapping without using SELECT
DISTINCT option in source qualifier?

How do we lookup data in the target and the source to compare them without using lookup
transformation? basically I mean getting lookup functionality without using lookup
transformation?

How many dimension tables did you had in your project and name some dimensions (columns)?

How to join two tables without using the Joiner Transformation.

If you had to split the source level key going into two seperate tables. One as surrogate and
other as primary. Since Informatica does not gurantee keys are loaded properly(order!) into
those tables. What are the different ways you could handle this type of situation?

We can insert or update the rows without using the update strategy. Then what is the necessity
of the update strategy?

What is a transforamation? It is a repostitory object that generates,modifies or passes data.

What is E-R modelling and why is it used for OLTP designwhat is dimesional modelling and why
is it used for datawarehouse desgn

What is redo log file in Informatica ?.

What is the difference between Enterprise data warehouse and a data warehouse ??Which all
transform

What is the logic will you implement to load the data in to one factv from 'n' number of dimension
tables?

What is worklet and what use of worklet and in which situation we can use it

With out using Updatestretagy and sessons options, how we can do the update our target table?

Can you look up a flat file ? How ?2.What is test load?

How can we delete the cache files while we using aggregator transformaation?

How do we remove the staging area

How many Fact and Dimension tables are there in your project?

How to load data to target where the source and targets are XML'S?

If you have four lookup tables in the workflow. How do you troubleshoot to improve
performance?

What the circumstances that infromatica server results an unreciverable session?

What is a transformation?

What is Event-Based Scheduling?

What is referential Intigrity error? How ll you rectify it?

What is the difference between Informatica 6.2 and Informatica 7.

What is the look up transformation?

What is worklet?

Without using ETL tool can you prepare a Data Warehouse and maintain?

Can you look up a flat file using Informatica?

How can we display delimiters beside column names of target flat file?

How do you add and delete header, footer records from flat file during load to oracle?

How many joiner transformations needed to join 10 different sources.

People who read this, may find the below Interesting