What is surrogate key?

Answer Posted / koti

sarrogate key is ssystem generated sequence number,an
artificial key. which can be used in maintaing the history
of the data

Is This Answer Correct ?    24 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is union transformation utilized?

572


Describe the impact of several join conditions and join order in a joiner transformation?

649


What you know about transaction control transformation?

563


Parameter and variable differences

1619


How does the aggregator transformation handle null values?

703






What is dimensional table? Explain the different dimensions.

666


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640


What is an unconnected transformation?

667


whats the logic to load the lower level of granularity of data to fact table.

1807


Differences between connected and unconnected lookup?

610


Plz can any one say me how to get the informatica certification materials and dumps

1600


Explain lookup transformation source types in informatica

702


what is the complex transformation you used in informatica

2194


Enlist the differences between database and data warehouse.

553


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1473