how to find no.of records in sequntial file itself?

Answer Posted / mandru naganji

in seq file set row number column and it will generate data like 1 to n depending onm num of rows.use sort satge desc order get last record.u will get count

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the process of killing a job in datastage?

593


Explain datastage architecture?

820


What are the some differences between 7.x and 8.x version of datastage?

742


What are stage variables and constants?

702


What is a quality stage in datastage tool?

631






How to perform incremental load in datastage?

669


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

528


What are the types of containers?

691


What is the method of removing duplicates, without the remove duplicate stage?

588


What is the difference between in process and inter process?

671


Name the third party tools that can be used in datastage?

618


What are the important features of datastage?

617


Explain the situation where you have applied SCD in your project?

1562


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

970


How do you import and export the datastage jobs?

735