Data Warehouse Developer Interview Questions and Answers – Page 4

How can i edit the XML target, are there anyways apart from the editing the XSD file.Can i directly edit the XML directly in Informatica designer.

When I assigned a primary key to my table in Microsoft Access, I was expecting my data to be sorted. Am I using the correct procedure?

What is the maximum size of a database that can be opened in Microsoft Access?

What is the difference between the full, simple and bulk log recovery models?

Table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A columns all three rows

Give me an example of an assignment that you found difficult to finish? How did you go about it?

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

If a table contains 100 records we have to fetch 50-100records from source to target?how

Which command displays the SQL command in the SQL buffer, and then executes it

Can you create a table with Primary Key not as the clustered index.

What is the size limitation of an Access database?

What is a three tier data warehouse?

What is the result of this query if no rows are selected:

What does "tee" command do in MySQL?

What are the various tools? - Name a few.

What is LINQ?

What are Lexical Parameters.How They are used in Reports 6i

Describe a time when you took extra effort to make sure the person with whom you were communicating with had really understood your point. How did you do this?

What is different between int and bint?

What does the following query do

Give me an example of a time when you had to put your point across in a meeting to which most of the people were reluctant to hear.

How to get duplicate records from tables?write qurey for this?

With DTS packaging I can store tables in Excel and convertthem back to SQL. But once I copied tables to Excel I wantto modify some info. How you do that without editing theExcel file?

Use mysqldump to create a copy of the database?

How to find the date and time of last updated table?

How do you create an append query?

Explain about the protection features present in MS Access?

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

What is merging?