1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

How you Remove the Dataset in Unix?

5 Answers  

---

Highlight the main features of datastage?

0 Answers  

---

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

How to read the length of word in unix?

0 Answers   CTS,

---

how to convert rows into columns

2 Answers   IBM,

---

What are the features of datastage flow designer?

0 Answers  

---

How to add zero "0" before record in a field?

4 Answers  

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

What are routines in datastage?

0 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---