How do you load dimension data and fact data? Which is first

Question Posted / kiran

2 Answers
15314 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you load dimension data and fact data? Which is first..

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

How do you load dimension data and fact data? Which is first..

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

Post New Answer

More Data Stage Interview Questions

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers

WHAT are unix quentios in datastage

2 Answers TCS,

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers Cap Gemini,

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers TCS,

what is the differeces between hash and modulus partition methods

4 Answers TCS,

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers Virtusa,

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers

What are the steps required to kill the job in Datastage?

0 Answers

where we use column generator stage in real time scenario?

5 Answers TCS,

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers

What are data elements?

0 Answers

For more Data Stage Interview Questions Click Here