Answer / ds

Syntax:
Dsjob -run project_name job_name (if any parameter give those also)

Answer / nams

join [options] file1 file2 &

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

Explain ibm infosphere information server and highlight its main features?

0 Answers  

---

what is executable in DataStage?

2 Answers  

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

---

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

1 Answers   Infosys,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

what is the use of materialized view?

0 Answers   CTS,

---