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  

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

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,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

what is parameterset?

4 Answers   Wipro,

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---