Answer / vamsi

hi,
it's simple one only
take sourse----->copy----> t1,t2,t3

in copy stage we map the in put columnes to out put as we required like col1 to t1,col2 to t2,col3 to t3...

Answer / sindhu

transformer field function

What are the different types of lookups in datastage?

0 Answers  

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

Which commands are used to import and export the datastage jobs?

0 Answers  

---

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 all the types of jobs you developed?

0 Answers  

---

Difference between data warehousing and olap?

0 Answers  

---

What are stage variables, derivations and constants?

0 Answers  

---

how to handle null values using transformer stage?

1 Answers  

---

how do u capture duplicates through sort & transformer

4 Answers  

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

---

How to initialize environment variables?

4 Answers   Infosys,

---

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,

---