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

Informatica Interview Questions

Questions Answers Views Company eMail

Quickly characterize reusable change?

1126

What do you mean by channel change?

1051

What are the measure objects?

1211

What are the different types of transformation available in informatica.

1106

Explain what are the different types of transformation available in informatica.

1152

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1083

How to do unit testing in informatica? How to load data in informatica ?

1130

Explain the different dimensions.

972

Differentiate between source qualifier and filter transformation?

1584

Explain scd type 3 through mapping.

1023

What is dimensional table?

1072

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1588

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1127

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1173

Explain in detail about scd type 1 through mapping.

1557

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1908

State the differences between sql override and lookup override?

1215

Make a note of the quantity vaults made in informatica?

989

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 a transaction control transformation?

1213

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

971

Write the different tools in the workflow manager?

1071

How to load last n records of file into target table - informatica

1083

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

1020

What are the mapping parameters and mapping variables?

1210

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1867

To import the flat file definition into the designer where should the flat file be placed?

1061

COM components can be used in Informatica

2397

what are the deliverables?in your project?

2152

What are multi-group transformations?

1113

For More Un-Answered { Informatica } Questions Click Here