Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 12724 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
which r the connectors used in san?
Notification Activity
How do you generate sequence number in datastage?
What is the purpose of pivot stage and types of containers in datastage
What is a ds designer?
Why we use surrogate key?
CHANGE CAPTURE
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
On which interface you will be working as a developer?
How do you start developing a datastage project?
Explain the importance of surrogate key in data warehousing?
How you can fix the truncated data error in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
