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,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

What are the different layers in the information server architecture?

0 Answers  

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

---

how does work server jobs?

1 Answers  

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

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 how a source file is populated?

0 Answers  

---

What are the components of datastage?

0 Answers  

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---