Data Warehouse Developer interview questions – page 16

What is ZOOM?How it works

What is use of APPDAYPK library?

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

What is the maplet?

Is a fact table normalized or de-normalized?

What are the connected or unconnected transforamations?

What is a transforamation?

What is Code Page Compatibility?

How does indexing improve query performance?

Define the "integrity rules"

Diffrence between VIEW and MATERIALIZED VIEW?

What are the triggers we should not modify?

What r the methods for creating reusable transforamtions?

What is source qualifier transformation?

Can anyone explain about incremental aggregation with an example?

What are the steps you have to follow to register a Form?

What is one major characteristic or skill that you possess which you believe will complement our current management team? Please explain how this characteristic or skill distinguishes you.

How do we enhance the functionality of the reports in BO?

What is BAS? What is the function ?

What are the steps you have to follow to register a custom application?

Know the reason why to register a server to the repository is necessary

What is customization?

Is the increase in CRR rate a good sign for Indan economy and why?

Any work done in Oracle Workflow builder. Did you customize or build a new workflow.

Can anyone explain about Auditing in BO XI R2?What is the use of it??

Define piconet.

I would like to know the detail coding and procedure of connecting Oracle and Sql with VB and VB.Net

Define and expansion of ssl.

What is the maximum number of rows in a table in Firebird?

Table name stud,a mark 23,b mark 87,c mark 75,d mark 34;write the query to find 2nd highest mark in stud table?