Why we use surrogate key?

0 Answers  

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

What are constraints and derivations?

0 Answers  

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

How can u write exception handling in seq file????

2 Answers   IBM,

---

---

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---