Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---

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  

---

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 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 in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---