What is the difference between Datastage 7.5 and 7.0?

0 Answers  

---

How do you find the number of rows in a sequential file?

1 Answers  

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

What is the use of datastage designer?

0 Answers  

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

how do you pass parameters in a script?

1 Answers   L&T,

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

What is use Array size in datastage

0 Answers  

---