Primary Key for the dimension table is its own primary Key PRimary Key for

How can u execute the sql query through unix?
What is the Primary key for Dimension table?
what is the primary key for Fact table?

Question Posted / bala

5 Answers
12519 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / bala

Primary Key for the dimension table is its own primary Key
PRimary Key for Fact table is Foriegn key which dirived from
Dimensional table

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2457

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2810

Is the value of staging variable stored temporarily or permanently?

992

Can you explain tagbatch restructure operator?

1167

Differentiate between Join, Merge and Lookup stage?

1088

EXPLAIN SCD

1389

explain about citrix scheduling tool in datastage

2445

Can we use target hash file as a lookup ?

3323

Define Job control?

1138

What is the use of hoursfromtime() function in transformer stage in datastage?

1059

How to find value from a column in a dataset?

2192

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2219

What is a merge?

1157

What are the repository tables in datastage?

1301

How many Key we can define in remove duplicate stage?

1372