why we are using surogate key in real time give me
explanation

Answers were Sorted based on User's Feedback



why we are using surogate key in real time give me explanation..

Answer / nagendra phani

SUROGATE KEY is used to generate a primary key. and it is
system generated number

Is This Answer Correct ?    4 Yes 1 No

why we are using surogate key in real time give me explanation..

Answer / davan

Mainly we r using...the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


how to return multiple columes through through un-connect lookup?

1 Answers   DELL,


Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


Explain what is informatica metadata and where is it stored?

0 Answers  


what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,






comonly how meny mappings r there in Banking projects?

1 Answers  


in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,


What is a router transformation?

0 Answers  


In joiner, how to load Master table in Target?

2 Answers  


How can we create index after completion of load process?

0 Answers  


if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


Categories