| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How will you determine the sequence of jobs to load into data warehouse?
Answer: First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any). |
| August 08, 2008 07:21:47 |
#2 |
| umamahesh.ds |
Member Since: July 2008 Total Comments: 2 |
RE: How will you determine the sequence of jobs to load into data warehouse?
|
| Simply by using "usage variyable" stage in job sequencers. |
| |
Back To Question | |
