Informatica Interview Questions

Etl developer daily routine and reporting hierarchy

Can anybody plz explain what would be the daily routine and reporting hierarchy of an etl developer in sales project...

Real-time lookup transformation usage

How and for what purposes we use look up transformation in sales or banking project?

How do you evaluate the performance of powercenter mapping with 10 records ?

How to write etl automation scripts ?

How would you explain about Informatica project ?

Can any one please tell me how to explain data warehouse project in interview and from where to start and end. What to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.What...

Pull data from SAP financials using Informatica

Hi, I want to know the processes for pulling the data from SAP financials using Informatica and write scripts to locate the required data.Thank you.

How to pull the data

Hi,how to pull the data from XML and flat files in Informatica?How to pull the data from materialized view in Informatica?

Employee datawarehouse

I want to know what are the steps to be followed to create a employee datawarehouse.What actions needs to be performed.

Transformation scope

Explain how transformation scope effects joiner transformation?

Mapping logic

Give any one logic you have implemented in mappinig except SCD type2 (real time logic)?

How can we cascade triggers?

Does Informatica provide a sas exit in any of its products?

What I am trying to determine is if I could invoke a sas session from within Informatica's etl product(s) in order to execute a complicated transformation written in sas which would then return the results to Informatica. We have a very complicated application written in sas that we are evaluating as...

What is re-dimension?

How can you migrate mappings and sessions from Informatica 6.2 to Informatica 7.1?

You need to prepare common documentation of session+it's source and target.How do you make it with mvx views?

What is jms and what is the relation between powerconnect and jms?

What is suggested method for validating fields/marking them with errors?

Hi,in power center 7.1.2 how can we take a backup of a versioned repository such that I get a non-versioned repository when I restore it.I need a way to get a non-versioned repository from a versioned...

Talk about the kimball vs. Inmon approaches.Talk about the concepts of ods and information factory.Talk about challenges of real-time load processing vs. Batch.

How to perform a "loop scope / loop condition" in an Informaticaprogram ? Give me few examples .