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

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

what is sparse lookup?

7 Answers   IBM,

---

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

What is aggtorec restructure operator?

0 Answers  

---

What are the third party tools you used in your project?

1 Answers   IBM,

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

---

What is the purpose of pivot stage?

0 Answers  

---

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,

---