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 12743

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

Cap Gemini,

5 42593

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

TCS,

8 9989

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

Yash Technologies,

5 9993

What is polling in informatica ?

TCS,

1 12014

how to delete duplicate records by using filter transfermation?

3 7969

what is unit testing?tell me proceedure

L&T, UST,

2221

Tell me one complex query in oracle ?

L&T, Satyam,

2 7855

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

TCS,

3 9304

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10594

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

2171

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

2339

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 }

Please let me know how to make Data masking in informatica..

1721

What is workflow? What are the components of the workflow manager?

1139

How would you join a node to the already existing domain?

1130

What is incremental aggregation?

1083

What is the sql query overwrite in source qualifier in informatica

1090

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

2379

What is a dimensional model?

979

What's the layout of parameter file (what does a parameter file contain?)?

2385

Mention few advantages of router transformation over filter transformation.

1023

r u done any partitions in ur project?

1827

Where are the source flat files kept before running the session?

1078

Explain the tuning lookup transformation - informatica

994

What is the surrogate key?

1261

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2036

What is data caches/ index caches?

1105

For More Un-Answered { Informatica } Questions Click Here