I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

Answer Posted / subhash (subbuchamala)

If we use @INROWNUM, then we have to run transformer on 'single' NODE.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3364


Demonstrate experience in maintaining quality process standards?

1916


What is the use of datastage director?

577


Define data aggregation?

658


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1028






Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1113


How do you reject records in a transformer?

621


how to implement scd2 in datastage 7.5 with lookup stage

5119


What are some different alternative commands associated with "dsjob"?

643


State the difference between an operational datastage and a data warehouse?

598


What is meta stage?

569


How to reverse the string using SQL?

881


How to find value from a column in a dataset?

1761


What is a folder? Difference types of stages?

615


Difference between in process and inter process?

687