Answer / amit trivedi

We need to use external tables to join a flat file and oracle table.
First insert all records of flat file into an external table and then join these two tables.

else, use next step, insert data from external table to oracle table and join these two tables using join conditions.

Answer / lokesh

first we need to converted flat files in tables ofter join
the oracle and that table

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

---

what is a message handler

3 Answers   IBM,

---

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

0 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

---

What is difference between server jobs & parallel jobs?

0 Answers  

---

How can we improve the performance in datastage?

0 Answers  

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

Difference between sequential file and data set?

0 Answers  

---

Define repository tables in datastage?

0 Answers  

---

On which interface you will be working as a developer?

0 Answers  

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---