Answer / vijaya

Hi

Its all depends on the source data if the data is coming
through oracle datastage then go for oracle enterprise stage
if it a incremental load but if it is initial load then go
for oracle bulkloader stage.Oracle enterprise is faster as
compare to ODBC.oracle enterprise runs parallel where as
ODBC runs seq.

Answer / ravi kumar

oracle enterpaise stag is best becs we can use develope any
one.

Answer / raj

better go 4renterpaise stage

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

can explain wt is the pool for file.

1 Answers   CTS,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

What is orabulk stage?

0 Answers  

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---