Answer / subhash

1. SRC---->TFM---->TGT1,TGT2,TGT#
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
C1 1
C2 2
C3 3
c4 4
c5 5
c6 6
c7 7

in TFM,
put below condition for each target link.
TGT1--->MOD(ROWNUM,3)=1
TGT2--->MOD(ROWNUM,3)=2
TGT3--->MOD(ROWNUM,3)=0

What is difference between server jobs & parallel jobs?

0 Answers  

---

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

What is the difference between datastage and informatica?

0 Answers  

---

Can you explain repository tables in datastage?

0 Answers  

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---

what is flow of project?

0 Answers   HSBC, IBM,

---