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 12745

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

Cap Gemini,

5 42602

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

TCS,

8 9991

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

Yash Technologies,

5 9997

What is polling in informatica ?

TCS,

1 12014

how to delete duplicate records by using filter transfermation?

3 7971

what is unit testing?tell me proceedure

L&T, UST,

2223

Tell me one complex query in oracle ?

L&T, Satyam,

2 7863

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

TCS,

3 9305

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10598

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

2179

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

TCS,

2 7654

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

2340

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

TCS,

2 7248

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 }

What are the new features of Power Center 5.0?

1779

What are the types of lookup transformation?

1081

What is the difference between writing a joiner query in ANSI style and THETA style?

2381

What is the command used to run a batch?

1064

what is the complex transformation you used in informatica

2588

What is the benefit of partitioning a session?

1182

Explain sessions and how many types of sessions are there?

1011

How can we use mapping variables in informatica? Where do we use them?

1203

Explain constraint based loading in informatica

1096

Sequence generator, when you move from develoment to production how will you reset

2040

complex mapping ur project u r invlve can u explain and give real time example give me ?

2301

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

1070

Under which circumstances, informatica server creates reject files?

1095

What are the uses of etl tools?

1128

What is the session task and command task?

1060

For More Un-Answered { Informatica } Questions Click Here