How many indexes can be created on a table?
What is the use of default key?
What is difference between server and database?
What is the difference between a stored procedure and a query?
how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4
Explain inner and outer joins with examples.
What is the function of cluster index?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What does currency type mean in database?
What are the advantages of views in a database?
What are the advantages of normalizing a database.
What is the Difference Primary key and Unique Key
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage