DataStage Scenario based Interview Questions

1 Answers  

---

how to convert rows into columns

2 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,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

Differentiate between data file and descriptor file?

0 Answers  

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

---

What is the difference between orabulk and bcp stages?

0 Answers  

---

What is a datastage job?

0 Answers  

---

Define oconv () and iconv () functions in datastage?

0 Answers  

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---