Data Warehouse Developer Interview Questions and Answers – Page 9

If i am having 10 records in source, i want 20 records in target...how will you do it

What are the other commands to know the structure of table using MySQL commands except explain command?

What is the definition of derived table ?

Have you ever had to discipline a problem employee? If so, how did you handle it?"

What is the recommended way to send mail from SQLAgent in SQL Server 2005?

How do I submit a form or a part of a form without a page refresh?

Select distinct(empid),distinct(dept),namefrom EMPwill the above query work?

What is version control in informatica ?Advance thanks

How union transformation is active ?

What is a staging area? Do we need it? What is the purpose of a staging area?

A. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tablesc. If No, can you delete if there is single source table which is joining.

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'.Table 'B'contains 3 columns named'sid','designation','salary'.We have to retrieve the names of employees working in the same department,same designation and same salary.Its urgent can anyone help me out in this problem.

Which index created when Create Index on table(col), Why

Hi I have two sources like A, B. My source A contain 10000million records from that i need 20 attributes. My source Bhas also same 10000 million records from that i need only 1attribute. By using Joiner i have to load into target? Isthere any issue regarding this? if issue is there how totune this mapping in best way?

Name few built in sas transformation in DI studio ?

What are the different Lookup methods used in Informatica?

Write a query to find second highest salary of an employee.

How to display last 5 records in a table ?With out Top key word and doing order by descAdvance thanks

What does this return? declare @i intselect @i = -5select +@i

How does a differential backup know which extents have changed so that it can be very quickly run?

Explain the difference between mysql and mysqli interfaces in PHP?

Is there any way to read the MS Excel Data's directly into Informatica?Like IS there any Possibilities to take excel file as target?

How to determine what records to extract?

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

Can we lookup a table from source qualifier transformation. ie. unconnected lookup

How to insert and retrive images on MSACCESS using java

From an Employee table, how will you display the record which has a maximum salary?

What is procedure in sql?

Can we use Truncate command on a table which is referencedby FOREIGN KEY?

How can you quickly find out the number of rows updated after an update statement?