KyaPoocha.com

Related Interview Questions

• Why do we use Surrogate Key?  28.11.08

  It is the system generated key which cannot be edited by the user. It is the primary key of the dimension table in warehouse. It is nothing but the sequence...

• What is Variant data type in VBScript?  21.11.08

  VBScript has only one data type called a Variant. A Variant is a special kind of data type that can contain different kinds of information, depending on how it'...

• What is Variant data type in VBScript?  31.10.08

  VBScript has only one data type called a Variant. A Variant is a special kind of data type that can contain different kinds of information, depending on how it'...

• what is abstract data type?  29.10.08

  Abstract data type logical cohesion of operands or variables along with set of operation which can be performed on it. In Java we have most of data types as...

• What is the datatype of the surrgate key ?  22.09.08

  Normally Surrogate keys are sequencers which keep on increasing with new records being injected into the table. The standard datatype is integer...

• What is the need of surrogate key;why primary key not used as surrogate key Surrogate key is system generated unique number ?  22.09.08

  Identity in SQL, Sequence in Oracle, Sequence Generator in Informatica. For Example : You are extracting Customer Information from OLTP Source and after ETL...

• What is the role of surrogate keys in data warehouse and how will u generate them?  20.09.08

  A surrogate key is a simple Primary key which maps one to one with a Natural compound Primary key. The reason for using them is to alleviate the need for the q...

• What is surrogate key ? where we use it explain with example ?  20.09.08

  surrogate key is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to th...

• What is the difference between TYPE 1 index & TYPE 2 index ?  26.03.08

  TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retrie...

• Can u print decimals in type N? What is difference between float and packed data type?  06.03.07

  No, we cannot print decimals in type N because decimal places are not permitted with N data type. Float Data Type: It cannot be declared in Parameters. Pack...