Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Different types of Power center errors?

Cinterco, IBM,

1 8044

Define Update Override?

1 4744

Define error Threshold?

1 5032

Examples of Fatal & Non-Fatal error?

Cap Gemini,

2 22490

Difference Between ETL & ELT?

TCS,

1 7718

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 7783

Define Incremental Aggregation?

2 6886

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

Wipro,

3 9017

Can we use parameters of parameter file in presession command

Wipro,

1 7088

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

HCL,

4 8915

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

Accenture,

1 5018

What is galaxy shema

CGI,

2 7077

which one is better either active or passive transformation in informatica

1 4858

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2110

What is the difference b/w natural key and surrogate key

1 5482

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the need for an etl tool?

1068

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

What all are steps in up gradation of Informatica server?

1045

What are the differences between oltp and olap?

972

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2066

What the difference is between a database, a data warehouse and a data mart?

1155

What are the limitations of joiner transformation?

1114

What is substr in informatica?

1208

Explain about Informatica server process that how it works relates to mapping variables?

1080

What do mean by local and global repository?

1226

tell me 5 session failure in real time how can you solve that in your project?

2305

Repository user profiles

1763

How to update or delete the rows in a target, which do not have key fields?

1178

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

tell me the rules and responsblites in our project(my project is development)

1933

For More Un-Answered { Informatica } Questions Click Here