surrogate keys usage in Oracle and Informatica?

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain lookup transformation is active in informatica

666


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4318


How to generate sequence numbers without using the sequence generator transformation?

649


What are the transformations that are not supported in mapplet?

604


What is informatica powercenter repository?

718






Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786


how tokens will generate?

1740


where to store informatica rejected data?

684


What is rank transformation in informatica

693


What is meant by query override?

640


What is Cognos script editor?

3790


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642


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

1602


What is source qualifier transformation in informatica?

579


What is joiner transformation in informatica?

629