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

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

Question Posted / nagendra phani

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is standalone command task?

1374

Explain the pipeline partition with real time example?

1200

Can you use flat files in Mapplets.

2713

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

Is it possible to revert a global repository to local one and why?

1135

Differentiate between sessions and batches?

1069

Explain the code page compatibility?

1119

What are data-driven sessions?

1261

What could be the possible resons of locks by user?

1144

What are the differences between oltp and olap?

1018

How to load a Dimension ? and how to load a fact table?

1461

what is $$$$?

2202

As union transformation gives UNION ALL output, how you will get the UNION output?

1159

Explain the tuning lookup transformation - informatica

1044

how we can load rejected record's at run time?(not through bad files)

2426