Data Warehouse Developer interview questions – page 10

Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)

How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?

What is DESCRIBE command in SQL Server?What is its purpose?How to use it?

What is SQL Profiler what is the use of it?

How do you add a developer to a trusted publishers list?

How many joins we can write if at all we have n no of tables

What is source qualifier?

I have a tablecol110203040102050my requirement is how to retrive only duplicates like10102020like this how it's possible in SQL?

How to call lookup qualifer in unconnected look;up

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ?Advance Thanks

Write a querry .if 10 records in a table.i want only 1 record and 3 reocrd and 10 record. how to write a querry.

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

I am designing an Access database form. How can I get my next control in the form to be automatically selected?

Describe way(s) to tune the SQL table in order to optimize performance

What is the toughest problem you've had to face, and how did you overcome it?

Do you need to make your attitude more positive when marketing yourself and your ideas to others?

Select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

Compare Data Warehousing Top-Down approach with Bottom-up approach

Hyperion is the one of the tool in data ware house.its an olap tool.y u cant display that tool?

Explain the informatica Architecture in detail

What are the features of Clipper VO?

Difference between summary filter and details filter?

How is file locking handled in Clipper?

Discuss the advantages & Disadvantages of star & snowflake schema?

What are all difference between business objects 6.5 and XI R2

How to define Informatica server?

What are the difference between view and materialized view?

Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.

Discuss which is better among incremental load, Normal Load and Bulk load

At the max how many tranformations can be us in a mapping?