Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15413 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / usha
first we load data into dimension table then we will loadin
to fact table..
dimensions and facts has parent and child relationship.
many to one relation
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the different layers in the information server architecture?
table actions available in oracle connector?
What is the version control how can i apply this in DataStage can any one tell me the anser
I have a few records just I want to store data in to targets cycling way how?
How to manage date conversion in Datastage?
Demonstrate experience in maintaining quality process standards?
Explain entity, attribute and relationship in datastage?
What is Cleanup Resources and when do you use it?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
Teradata 
