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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

1010

How do you convert single row from source into three rows into target?

1106

What are the types of schemas we have in data warehouse.

916

Why update strategy and union transformations are active? Explain with examples.

1192

How do you remove duplicate records in informatica?

1 1323

How do you load alternate records into different tables through mapping flow?

1820

How do you load first and last records into target table?

1117

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240

Explain in detail scd type 2 through mapping.

1001

How do you load unique records into one target table and duplicate records into a different target table?

1180

Explain the different kinds of facts.

947

How do you load only null records into target?

1162

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

1027

How many ways are there to do 'remove duplicate records in informatica'?

969

How to join three sources using joiner? Explain though mapping flow.

1112

Post New Informatica Questions

Un-Answered Questions { Informatica }

What can we do to improve the performance of informatica aggregator transformation?

1059

explan ur project architecture?

2020

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1245

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

2069

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

What are the different types of olap? Give an example?

994

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1099

How do you load unique records into one target table and duplicate records into a different target table?

1180

What are the different components of powercenter?

1005

How to create the source and target database connections in server manager?

1050

How union transformation is used?

971

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

10644

Tell me about MD5 functions in informatica

890

What is dimensional table?

1020

How you know when to use a static cache and dynamic cache in lookup transformation?

1815

For More Un-Answered { Informatica } Questions Click Here