Answer / sai suresh

surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.

Answer / shiva

surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys

Answer / reddy

surrgate key is not used for the bussiness

Answer / deepthi pathuri

A surrogate key in a data warehouse is more than just a
substitute for a natural key.

(OR)

A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.

Answer / pradeep

surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.

What is blocking transformation?

0 Answers   Informatica,

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

What is the surrogate key?

0 Answers  

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

how did u understand business requirement?

2 Answers   TCS,

What is the cumulative sum and moving sum?

0 Answers