Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15490 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
Explain the situation where you have applied SCD in your project?
Which commands are used to import and export the datastage jobs?
What are the partitioning techniques available in link partitioner?
Why fact table is in normal form?
Why we use surrogate key?
What are system variables and sequencers in datastage
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the enhancements made in datastage 7.5 compare with 7.0?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the differences between datastage and informatica?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is difference between server jobs & parallel jobs?
Explain datastage architecture?
Where do the datastage jobs get stored?
how to export or import the jobs in .ISX file
