Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

What are the features of datastage flow designer?

0 Answers  

---

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---

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,

---