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.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

what is sparse lookup?

7 Answers   IBM,

---

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,

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

Differentiate between datastage and informatica?

0 Answers  

---