How do you load dimension data and fact data? Which is first
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
How to Remove Duplicate using SQL?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Define ds designer?
What is the difference between validated and compiled in the datastage?
How do you generate sequence number in datastage?
Explain how a source file is populated?
Have you used Unstructured data?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
On which interface you will be working as a developer?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is ds administrator used for?
How do you start developing a datastage project?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How do u convert the columns to rows in datastage?
what are the errors,warnings in datastage