Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8617 Views
- IBM, I also Faced
- E-Mail Answers
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
What is the difference between datastage and informatica?
options available in sequence job to run,validate?
What are datastage sequences?
Define APT_CONFIG in Datastage?
What could be a data source system?
What are orabulk and bcp stages?
What are stage variables and constants?
Describe the main features of datastage?
What is the difference between passive stage and active stage?
What is datastage engine?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do you import and export the datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Define data aggregation?
