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 12596

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

Cap Gemini,

5 42326

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

TCS,

8 9673

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

Yash Technologies,

5 9780

What is polling in informatica ?

TCS,

1 11876

how to delete duplicate records by using filter transfermation?

3 7799

what is unit testing?tell me proceedure

L&T, UST,

2168

Tell me one complex query in oracle ?

L&T, Satyam,

2 7719

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

TCS,

3 9081

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10369

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

2133

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

TCS,

2 7528

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

2269

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

TCS,

2 7087

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,

2081

Post New Informatica Questions

Un-Answered Questions { Informatica }

Write the prerequisite tasks to achieve the session partition?

1075

What are the new features of Power Center 5.0?

1702

In which transformation you cannot drag ports into it?

1247

 Informatica Checkpoints

3273

Differentiate between a database and data warehouse?

1093

Parameter and variable differences

2007

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2689

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1994

How to generate sequence numbers using expression transformation?

1029

How do you change a non-reusable transformation to reusable transformation?

947

without table how to come first record only in oracle?

2207

What are the prerequisite tasks to achieve the session partition?

1180

What is lookup transformation?

1005

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1849

What is DR strategy for Informatica project?

1115

For More Un-Answered { Informatica } Questions Click Here