what are fact tables and dimension tables?
give example assuming one table.
Answer Posted / kathyayini
fact table is the collection of foriegn keys corresponding
primary keys in the dimention tables
dimention table is the table which contains primary key and
will give detail informati1on about perticular instance
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
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 the features of datastage flow designer?
What is staging variable?
EXPLAIN SCD
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is a merge?
What are the job parameters?
What are orabulk and bcp stages?
How do you schedule or monitoring the job?
What are the different kinds of views available in a datastage director?
explain about citrix scheduling tool in datastage
What are the difference types of stages?
What are the different common services in datastage?
Difference between data warehousing and olap?