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
- 12318 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
How do you import and export data into datastage?
How to read multiple files using a single datastage job if files have the same metadata?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Can we use target hash file as a lookup ?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Why do we use link partitioner and link collector in datastage?
What is the difference between the local container and shared container?
Describe routines in datastage? Enlist various types of routines.
How many Key we can define in remove duplicate stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the benefits of datastage?
How to find value from a column in a dataset?
what is ds administrator used for?
Define Merge?
