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

How to reverse the string using SQL?

907


To see hidden files in LINIX?

952


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2330


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

558


Define project in datastage?

680






How to read the length of word in unix?

898


What is "fatal error/rdbms code 3996" error?

672


What are stage variables?

649


What is ibm datastage?

615


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1812


How do you run datastage job from the command line?

612


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1147


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

968


What is the difference between operational data stage (ods) and data warehouse?

685


Differentiate between operational datastage (ods) and data warehouse?

682