What is normalization? Explain different levels of normalization?
Explain about relational operator join?
How can I detect whether a given connection is blocked?
How can you fix a poorly performing query?
What is the maximum length of an extended property?
In which table collections errors are stored.
What is the physical representation for a many-to-many relationship?
explain detail about ftp in datastage?
How can you log an error to the server event log from a stored procedure?
Explain about the storage and physical database design?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain the rollup operator?
Explain the cube operator?
How to customize error conditions.
How to combine two function together?