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)

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  

---

how to configure databases through datastage

2 Answers  

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

can explain wt is the pool for file.

1 Answers   CTS,

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

---