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

Informatica Interview Questions

Questions Answers Views Company eMail

What is hash partition?

2 8482

How can you define a transformation? What are different types of transformations in Informatica?

10 25538

What is query panel?

1 5609

What is a look up function? What is default transformation for the look up function?

ASM, TCS,

2 17175

What is difference between a connected look up and unconnected look up?

6 25741

What is staging area?

11 26978

What is data merging, data cleansing and sampling?

Satyam,

6 22964

What is up date strategy and what are the options for update strategy?

2 10385

Why do we use DSS database for OLAP tools?

2 6849

What is active and passive transformation?

10 41010

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 19769

How is Data Models Used in Practice?

1 5396

What is the difference between view and materialised view?

4 13069

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

IBM, Wipro,

2 21395

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38366

Post New Informatica Questions

Un-Answered Questions { Informatica }

Is it possible to use a client with different version than that of its Informatica server?

1141

Which files are created during the session rums by informatics server?

1180

On which transformations you created partitions in your project?

1348

What is an unconnected transformation?

1087

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2455

What is a stored procedure transformation?

1053

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

How might you approve all mappings in the archive all the while?

1018

How can you increase the performance in joiner transformation?

1190

How to delete duplicate row using informatica?

1046

How union transformation is used?

1006

what is the hint? how to use it to reduce the query processing in program?

7835

What is olap (on-line analytical processing?

1069

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1267

For More Un-Answered { Informatica } Questions Click Here