Answer / madhusudhan reddy.d

In running the job the columns may change from one stage to
other stages & at the same time we will be loading the
unnecessary columns in the stage that doesn't required to
process.So we can load only the required columns to target
database, as this is done by enabling the RCP.

Answer / vijaya

RCP is know as Run-time column propagation

In the run of the job the columns may change from one stage
to another

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

What is the difference between datastage and informatica?

0 Answers  

---

what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,

---

What are the various kinds of containers available in datastage?

0 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

What steps should be taken to improve Datastage jobs?

0 Answers  

---

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

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

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---