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)

Define ds designer?

0 Answers  

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

---

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

How do you remove duplicate values in datastage?

0 Answers  

---

What all are the different way to run a job?

0 Answers  

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

---

what is snow flack schema?

2 Answers  

---