Informatica interview questions – page 6

How do you identify existing rows of data in the target table using lookup transformation?

Can i start and stop single session in concurent bstch?

What is the difference between Narmal load and Bulk load?

What is tracing level and what r the types of tracing level?

What are the session parameters?

How to get particular record from the table in informatica?

Can you generate reports in Informatcia?

What are the real time problems generally come up while doing/running mapping/any transformation?can any body explain with example.

Can we use aggregator/active transformation after update strategy transformation

In a joiner transformation, you should specify the source with fewer rows as the master source. Why?

While running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?

Briefly explian the Versioning Concept in Power Center 7.1.

How do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?

What is the difference between connected and unconnected stored procedures.

How to retrive the records from a rejected file. explane with syntax or example

4. how to get the records starting with particular letter like A in informatica?

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

Which objects are required by the debugger to create a valid debug session?

Can we eliminate duplicate rows by using filter and router transformation ?if so explain me in detail .

What r the settiings that u use to cofigure the joiner transformation?

Can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.

How can we partition a session in Informatica?

Waht are main advantages and purpose of using Normalizer Transformation in Informatica?

What are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

What is the best way to show metadata(number of rows at source, target and each transformation level, error related data) in a report format

How u will create header and footer in target using informatica?

What are the options in the target session of update strategy transsformatioin?

If you want to create indexes after the load process which transformation you choose?

What is the logic will you implement to laod the data in to one factv from 'n' number of dimension tables.

How do u check the source for the latest records that are to be loaded into the target.i.e i have loaded some records yesterday, today again the file has been populated with some more records today, so how do i find the records populated today.