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

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)

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

Where the datastage stored his repository?

0 Answers  

---

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Difference between server jobs & parallel jobs?

0 Answers  

---

how to closeing records after 10,000 records come?

3 Answers  

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

How do you find the number of rows in a sequential file?

1 Answers  

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

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

0 Answers  

---