surrogate key is one type of key which is used to maintain history . it i

surrogate keys usage in Oracle and Informatica?

Question Posted / ranjan

Answer Posted / ranjan

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what are the different types of transformation available in informatica.

1036

What is depict expression change?

1023

State the limitations where we cannot use joiner in the mapping pipeline?

992

What are the main issues while working with flat files as source and as targets ?

1091

what is size of u r database?

2241

What is a stored procedure transformation?

982

What is rank transform?

940

what are 3 tech challenges/ common issues you face?

2276

What is an active transformation?

1036

What is aggregator transformation in informatica?

895

Repository user profiles

1705

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

1005

Explain target update override in informatica

1040

What are the different types of transformation available in informatica.

1028

how to load rows into fact table in data warehouse

1114