wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

In merge stage can we update the values?

3 Answers   TCS,

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

What is difference between server jobs & parallel jobs?

0 Answers  

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

Where the datastage stored his repository?

0 Answers  

---