if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

---

why we use hash file for lookup?

5 Answers  

---

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

Can we use target hash file as a lookup ?

0 Answers  

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---

Tell me the syntax of Configuration file?

1 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

What is job control?

0 Answers  

---

How did you reconcile source with target?

2 Answers   HP,

---

How can we achive parallelism

1 Answers   CTS,

---