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

2 Answers  

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

What is meta stage?

0 Answers  

---

What is the use of Row generator stage?

2 Answers  

---

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

---

What are the benefits of datastage?

0 Answers  

---

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,

---

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---