Answer / hanug

The DB tables will be created in two ways

1. By right clicking on on the navigator on any of the
folder, you can choose NEW -> Table definition

2. We can also create new table using Database stages.

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

Differentiate between odbc and drs stage?

0 Answers  

---

What is active and passive stage?

0 Answers  

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---