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

Informatica Interview Questions

Questions Answers Views Company eMail

What is a design?

1 3851

How to delete duplicate records in a flat file source?

2 8684

What is a configuration management?

1 4164

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 30990

what is the difference between lookupoveride and joiner?

3 7837

what is plsql table?

2 6438

how to declare array in plsql?

1 9460

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18259

How many cubes create from a single model?

1 4626

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 6117

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 13635

How will you display "Mr" for male & "Mrs" for female in target table?

7 12931

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 8912

How will you combine 3 different sources with a single source?

3 8640

how will you get 21 to 30 record from 50 records?

6 11752

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the scenario which compels informatica server to reject files?

1168

What is the status code in stored procedure transformation?

1182

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 size of u r source(like file or table)?

2272

What is the cumulative sum and moving sum?

1186

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1040

What is fact table? Explain the different kinds of facts.

1076

How can we update a record in the target table without using update strategy?

1148

What is aggregator transformation in informatica?

949

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2122

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106

How many transformations can be used in mapplets.

1935

Write the program through which the records can be updated?

1005

What are the different components of powercenter?

1055

What is the different lookup cache(s)?

1086

For More Un-Answered { Informatica } Questions Click Here