Answer / satyanarayana

INROWNUM generates the rownumbers according to the input
link data where as OUTROWNUM generates the rownumbers
according to the output link data

Answer / venugopal

INROWNUM counte incoming rows to a transformer stage and
OUTROWNUM counts out coming rows from a transformer stage...

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

how can we create tables in datastage?

1 Answers  

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

Define Job control?

0 Answers  

---

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

How do you import and export the datastage jobs?

0 Answers  

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---