1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

What is RCP

5 Answers   CGI, CTS,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

how to find out number of records imported into source file?

1 Answers  

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---