surrogate keys usage in Oracle and Informatica?

Answer Posted / mahendra reddy ongole

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention few advantages of router transformation over filter transformation.

642


How to generate or load values in to the target table based on a column value using informatica etl tool.

614


Explain sql transformation in script mode examples in informatica

608


What are the data movement modes in informatica?

707


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1874






explain abt ur project architecture?

1765


What are the new features of informatica 9.x at the developer level?

609


Please let me know how to make Data masking in informatica..

1272


What are Dimensional table?

622


What do you mean incremental aggregation?

628


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

1913


What if the source is a flat-file?

595


What is InformaticaPowerCenter?

694


what is degenerated dimension?

3160


Scheduling properties,whats the default (sequential)

1470