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...

Define oconv () and iconv () functions in datastage?

0 Answers  

---

What is the default execution order of the sequential file?

3 Answers  

---

how can u connect the client system directly at any time?

1 Answers   IBM,

---

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  

---

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,

---

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

How and where you used hash file?

0 Answers  

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

how do you pass parameters in a script?

1 Answers   L&T,

---