Data Warehouse Developer interview questions – page 14

What do you mean by static and local variable?

Xplain about light scans in Informix?

What r the tasks that Loadmanger process will do?

What is extent in Informix?

What are Drawback of cursor?

How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?

What r the different types of Type2 dimension maping?

What r the active and passive transforamtions?

We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.

What is the procedure to write the query to list the highest salary of three employees?

Name the directory having the FORMS source codes ( FMB files ) ?

What is Informix instance?

What are the vital features of Firebird that makes it powerful database?

Who conceived and designed the Informix database management system?

How can U create or import flat file definition in to the warehouse designer?

What is the use of incremental aggregation? Explain me in brief with an example.

In a sequential Batch how can we stop single session?

Can you have more than one content canvas view attached with a window?

What are dashboards?

In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?

How many ways you can update a relational source defintion and what r they?

What is a Data Cube?What is its use ?

Why we use partitioning the session in informatica?

What is template form?

What are the active and passive transforamtions?

Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server?

Why we use stored procedure transformation?

What is ORA-1555?

Who developed informix?

I need to set predefined condition. How I do this?