Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15290 Views
- I also Faced
- E-Mail Answers
Answer Posted / manikandan
1.First load the data in to Dimension tables from the
sourse table
2.Load the data into fact table from source by putting
lookup on to
the dimension tables (If it is a fact less fact table U
need to load
only dimension data other wise load the messers from source
also)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
On which Dimension Table you implemented SCD Type in your Project
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the stages in datastage?
What are iconv and oconv?
Define Job control?
what are the errors,warnings in datastage
How to reverse the string using SQL?
To see hidden files in LINIX?
How will you move hashed file from one location to another location?
Where the datastage stored his repository?
What is the different type of jobs in datastage?
What are the types of jobs we have in datastage?
What is a quality stage in datastage tool?
Nls stands for what in datastage?
How rejected rows are managed in datastage?
