Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15493 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 the difference between lookup and sparse lookup?
what is the use of surogate key in datastage
What are the job parameters?
What are the areas of application?
what is a nodemap constraint
what is repositery?
To see hidden files in LINIX?
What is the difference b/w Hash file and Lookup Fileset stages?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
what is the Difference Between Datastage Server Edition and Parallel Edition?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
Teradata 
