Answer / ranjan

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Answer / avinash kumar

If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica

Answer / mahendra reddy ongole

surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications

Answer / palani

Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.

Answer / tanmoy

A surrogate key is the substitution of natural primary key

What is the cumulative sum and moving sum?

0 Answers  

how to obtain performance data for individual transformations.

2 Answers  

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

what is mapping override?

2 Answers   Cap Gemini,

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

What is the command used to run a batch?

0 Answers  

Explain the types of transformations?

0 Answers  

What is a surrogate key?

0 Answers  

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

What are the various types of transformation?

0 Answers  

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers