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

Informatica Interview Questions

Questions Answers Views Company eMail

Different types of Power center errors?

Cinterco, IBM,

1 8133

Define Update Override?

1 4831

Define error Threshold?

1 5134

Examples of Fatal & Non-Fatal error?

Cap Gemini,

2 22631

Difference Between ETL & ELT?

TCS,

1 7804

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 7967

Define Incremental Aggregation?

2 6991

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

Wipro,

3 9125

Can we use parameters of parameter file in presession command

Wipro,

1 7184

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

HCL,

4 9068

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

Accenture,

1 5101

What is galaxy shema

CGI,

2 7174

which one is better either active or passive transformation in informatica

1 4923

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

2164

What is the difference b/w natural key and surrogate key

1 5574

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to generate or load values in to the target table based on a column value using informatica etl tool.

1120

State the limitations where we cannot use joiner in the mapping pipeline?

1109

What is a shortcut and copy in Informatica and how two are different with each other?

1245

What is enterprise data warehousing?

1108

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

1912

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2262

How to delete duplicate row using informatica?

1092

What are connected or unconnected transformations?

1176

Differences between version 7.x and 8.x.

1945

What is repository manager?

1028

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

Can we create multiple integration service on single repository?

1243

What is the use of target designer?

1123

How would you copy the content of one repository to another repository?

1064

can anyone explain me about retail domain project in informatica?

8005

For More Un-Answered { Informatica } Questions Click Here