Describe the main features of datastage?

0 Answers  

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

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

6 Answers   Syntel, TCS,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

What are the difference types of stages?

0 Answers  

---

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,

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

how can u connect the client system directly at any time?

1 Answers   IBM,

---

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  

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---