what is architecture of your datastage project???
i came across this question many times in interviews in specific what can i answer
plz help me
Write short notes on manual refreshes.
What is database design and development?
Explain the cube operator?
How can you fix a poorly performing query?
What is dbms and its application?
What are the three types of database design?
Can you instantiate a COM object by using T-SQL?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is an application role and explain a scenario when you would use one?
can you give me the syntax of named procedure??
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Can you have a nested transaction?