Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15390 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
Can we use target hash file as a lookup ?
What is process model?
CHANGE CAPTURE
what is the use of materialized view?
what is repositery?
What are the repository tables in datastage?
What is the difference between validated and compiled in the datastage?
Define oconv () and iconv () functions in datastage?
Why we use surrogate key?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do y read Sequential file from job control?
EXPLAIN SCD
Name the third party tools that can be used in datastage?
How to implement complex jobs in data stage?
What are the steps required to kill the job in Datastage?
