Informatica Interview Questions
Questions Answers Views Company eMail

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

Informatica,

700

which one is better performance wise joiner or look up

Informatica,

632

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

Informatica,

639

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

Informatica,

680

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

Informatica,

731

What is an unconnected transformation?

Informatica,

669

What is the status code in stored procedure transformation?

Informatica,

689

Explain dynamic target flat file name generation in informatica

Informatica,

652

update strategy transformation in informatica

Informatica,

645

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,

614

What is blocking transformation?

Informatica,

724

Explain the tuning lookup transformation - informatica

Informatica,

615

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

Informatica,

628


Post New Informatica Questions

Un-Answered Questions { Informatica }

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What is persistent lookup cache?

607


wat are deployement groups in informatica, how it will be used for developers

1262


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1214


What is data caches/ index caches?

619






can we override a native sql query within informatica? Where do we do it? How do we do it?

602


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

665


What is session task and command task?

651


What are the new features of informatica 9.x at the developer level?

609


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

657


What are the features of complex mapping?

651


difference between informatica 8.1.1 and 8.6

3246


What are the steps involved in the migration from older version to newer version of Informatica Server?

1590


Did u used latest transformations of 8.6.0? for what?

1481


What is different between the data warehouse and data mart?

630