Database Administrator (dba) interview questions – page 12

To provide support for Mainframes source data,which files are used as a source definitions?

What is tracing level?

What is the self-referencing constraint?

What is a LIKE table and how is it created?

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 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.

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?

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?

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

What are delete-connected tables?

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

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.

How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?

How to create primary key only on odd numbers?

What is the difference between stop and abort

Performance tuning in Informatica?

In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ?how can u do this ?