How do you load dimension data and fact data? Which is first
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 stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Different ways a project can be moved to production ?...example ….export-import and Version control.
Describe stream connector?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how to design the change capture stage in(data stage parallel jobs) type 2
how to create document in datastage?
what is the use of materialized view?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How can we achive parallelism
how to call routines in stages?
What is meta stage?