Yes, we need to add the surrogate key in table.

suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?

Question Posted / shaj

Answer Posted / shaj

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to export mappings to the production environment?

853

What is the differences between star and snowflake schemas?

1011

What should I have in mind when building olap solution from scratch?

948

How to load the time dimension?

977

What are session timeout and application timeout?

983

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

954

How to stop a batch?

932

What is perform recovery?

1029

What is batch processing?

985

Explain what are necessary tasks to install reportnet software?

875

What are the steps involved in designing a fact table?

860

How to handle multi value dimensions?

2243

How to import vsam files from source to target. Do we need a special plugin?

910

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2228

Explain the difference between oltp and olap?

1075