Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15392 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 |
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
job locking methods? How can we unlock the job?
What are transforms and what is the differenece between routines and transforms?
how to validate the jobs
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
Unix command to view the data in a dataset
What a datastage macro?
What all the types of jobs you developed?
How do you generate sequence number in datastage?
source file contains 100 records, i want 10 records in target file how it possible in datastage
Define data aggregation?
Teradata 
