Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

what is the difference between INROWNUM AND OUTROWNUM IN
DATASTAGE SERVER EDITION?

Question Posted / venugopalds8

Answers were Sorted based on User's Feedback



what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?..

Answer / satyanarayana

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

Is This Answer Correct ?    15 Yes 0 No

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?..

Answer / venugopal

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

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More Data Stage Interview Questions

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

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

3 Answers   TCS,

What are the different database update actions available?

1 Answers   HP,




I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

What are data elements?

0 Answers  

Could anyone give brief explanation bout datastage admin

0 Answers  

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

What is the different type of jobs in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories