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

Informatica Interview Questions

Questions Answers Views Company eMail

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 12731

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 42576

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

TCS,

8 9965

I want load the data into target with out 1st and last record.

Yash Technologies,

5 9976

What is polling in informatica ?

TCS,

1 12007

how to delete duplicate records by using filter transfermation?

3 7965

what is unit testing?tell me proceedure

L&T, UST,

2219

Tell me one complex query in oracle ?

L&T, Satyam,

2 7840

How to delete the data in the target table after loaded.

TCS,

3 9293

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10576

what is diff b/t sorter t/r and agg have the option sorter property...

2169

How to delete the (flat file) data in the target table after loaded.

TCS,

2 7645

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2319

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

TCS,

2 7231

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

Patni,

2121

Post New Informatica Questions

Un-Answered Questions { Informatica }

whats the logic to load the lower level of granularity of data to fact table.

2271

What is the function of aggregator transformation?

1080

Define mapping and session?

1033

Define Pmrep command?

1050

What is event and what are the tasks related to it?

1118

differences between service based and product based?

2010

Mention some types of transformation?

1042

how tokens will generate?

2196

What is informatica etl tool?

996

How to update a particular record in target with out running whole workflow?

1574

explain one complex mapping with logic? sales project?

6663

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

961

Explain your project of banking domian.

1650

What is an Integration service in Informatica?

1128

What is a repository? And how to add it in an informatica client?

1145

For More Un-Answered { Informatica } Questions Click Here