Informatica Interview Questions
Questions Answers Views Company eMail

I have a flat file, want to reverse the contents of the flat file

Informatica,

698

which one is better performance wise joiner or look up

Informatica,

630

write a query to retrieve the latest records from the table sorted by version(scd)

Informatica,

636

How many types of sessions are there in informatica.please explain them?

Informatica,

678

Which transformation is needed while using the Cobol sources as source definitions?

Informatica,

730

What is an unconnected transformation?

Informatica,

667

What is the status code in stored procedure transformation?

Informatica,

688

Explain dynamic target flat file name generation in informatica

Informatica,

652

update strategy transformation in informatica

Informatica,

644

Difference between Data and Index Caches?

Informatica,

662

How many ways are there to create ports?

Informatica,

731

Which means the first record should come as last record and last record should come as first record and load into the target file?

Informatica,

613

What is blocking transformation?

Informatica,

722

Explain the tuning lookup transformation - informatica

Informatica,

615

Explain about Informatica server process that how it works relates to mapping variables?

Informatica,

627


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the Process to creating lookup transformation in informatica

587


What are the types of caches in lookup?

577


Global and Local shortcuts. Advantages.

1472


what is the -ve test case in your project.

1855


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

644






Which transformation is needed while using the Cobol sources as source definitions?

730


Can we create a node as a gateway node and the same node can be assigned to a grid?

641


Differentiate between a repository server and a powerhouse?

582


What is informatica powercenter repository?

716


How to improve the performance of a session using sorter transformation?

693


Define Pmrep command?

642


Is it possible to create multiple domains on a single Informatica server?

760


Explain the informatica workflow?

591


Which is the t/r that builts only single cache memory?

714


How to partition the Session?

648