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

Informatica Interview Questions

Questions Answers Views Company eMail

How can you access the remote source into your session?

1 6248

What is difference between partioning of relatonal target and partitioning of file targets?

2 13887

what are the transformations that restricts the partitioning of sessions?

1 8946

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43635

What is power center repository?

1 11807

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8737

What are the new features in Informatica 5.0?

1 4823

what is incremantal aggregation?

1 6014

What are the scheduling options to run a sesion?

2 11506

What is difference between stored procedure transformation and external procedure transformation?

2 14440

Explain about Recovering sessions?

1 6107

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 18889

How to recover the standalone session?

2 7156

How can you recover the session in sequential batches?

1 9703

How can you complete unrcoverable sessions?

1 5507

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1154

What is exclusive and normal mode for repository services?

1144

What is resilience time?

1137

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

According to his methodology what all you need before you build a datawarehouse

1757

What are the components of workflow manager?

1096

How can we handle two sessions in informatica?

1032

How do you manage the Parameter files while migrating your data from one environment to another environment?

1017

How big was your fact table

1803

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

1141

difference between repository database and repository service?

1150

How can we delete duplicate rows from flat files?

1223

what is unit testing?tell me proceedure

2221

Define enterprise data warehousing?

1204

What are the differences between a connected lookup and unconnected lookup?

1070

For More Un-Answered { Informatica } Questions Click Here