how can we join one oracle & flat files ?

2 Answers   ME,

---

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

0 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

how to add a new records into source?

0 Answers  

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---