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
- 12409 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
what is the use of skid in reporting?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is meta stage?
How do you reject records in a transformer?
What are stage variables, derivations and constants?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to RD using transformer?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how to write server Routine coding?
Differentiate between operational datastage (ods) and data warehouse?
What are the partitioning techniques available in link partitioner?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
In Datastage, how you can fix the truncated data error?
Define Merge?
