Data Warehouse Developer interview questions – page 11

What does the expression n filter transformations do in Informatica Slowly growing target wizard?

What is the difference between Narmal load and Bulk load?

Can we use aggregator/active transformation after update strategy transformation

Why are views used in the data blocks of a standard form instead of mapping directly into the base tables?

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

What is the option or command used in Informix for finding which dbspace a database resides?

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

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

What is chunk in Informix?

Clearly explain the difference between union and group

How can we partition a session in Informatica?

How Do I Make Remarks In My Code?

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

Difference between DBMS & RDBMS?

How to create the staging area in your database

How to lookup the data on multiple tabels.

Name the directories where you have to copy your Fmb and Fmx files?

What is meant by Junk Attribute in Informatica?

How can we use pmcmd command in a workflow or to run a session

What are the different types of data warehousing?

What is the difference between summary filter and detail filter

What r the diffrence between joiner transformation and source qualifier transformation?

Which tasks can be performed on port level(using one specific port)?

What is the meaning of FND in AOL

What is component of sga?

Define pre-emptive and non-pre-emptive.

What is use of custom library?