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

Informatica Interview Questions

Questions Answers Views Company eMail

How can you access the remote source into your session?

1 6347

What is difference between partioning of relatonal target and partitioning of file targets?

2 13977

what are the transformations that restricts the partitioning of sessions?

1 9073

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43720

What is power center repository?

1 11889

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8843

What are the new features in Informatica 5.0?

1 4898

what is incremantal aggregation?

1 6128

What are the scheduling options to run a sesion?

2 11619

What is difference between stored procedure transformation and external procedure transformation?

2 14560

Explain about Recovering sessions?

1 6194

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 19086

How to recover the standalone session?

2 7257

How can you recover the session in sequential batches?

1 9804

How can you complete unrcoverable sessions?

1 5592

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is an expression transformation in informatica?

1095

COM components can be used in Informatica

2457

What are the different options available for update strategy?

1055

What are the different types of olap? Give an example?

1099

Which transformation should we use to normalise the COBOL and relational sources?

1274

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

2799

What are the types of caches in lookup? Explain them.

1016

Please let me know how to make encryption and decryption with example?

1950

What is the procedure for creating independent data marts from informatica 7.1?

1121

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1994

How to implement security measures using repository manager?

1246

How are the sources and targets definitions imported in informatica designer?

1174

What is dimensional table? Explain the different dimensions.

1258

Did u used latest transformations of 8.6.0? for what?

1933

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3929

For More Un-Answered { Informatica } Questions Click Here