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

Answers were Sorted based on User's Feedback



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

Answer / varma

Option1: You can use wc –l <<filename>> | awk '{print $1}'
in “Execute command” stage to get the row count.

Option2:-Read the sequential file and after the stage
finishes successfully, you can get the link count using
DSGetLinkInfo(DSJ.ME,
DSJ.ME, “Yourlinkname”,DSJ.LINKROWCOUNT)

Is This Answer Correct ?    6 Yes 0 No

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

Answer / mmmm

Hi Simha..,

If u know then only give proper ans otherwise Shutup ur
asloe.Our AllInterveiw Community give one golden award for
u.its a Simha "Gaaandu"

Is This Answer Correct ?    15 Yes 14 No

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

Answer / 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

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

Answer / simha

hi,

seq file --> go for options --> select row count.
then automatically updated.

Is This Answer Correct ?    5 Yes 13 No

Post New Answer

More Data Stage Interview Questions

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

2 Answers   Infosys,


how to configure databases through datastage

2 Answers  


How can we do null handling in sequential files

3 Answers   Reliance,


what is the differeces between hash and modulus partition methods

4 Answers   TCS,


What are the benefits of datastage?

0 Answers  






Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,


Difference between data warehousing and olap?

0 Answers  


what is snow flack schema?

2 Answers  


how many types of sorting the data in data stage?

1 Answers   BoA, IBM,


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


DataStage Scenario based Interview Questions

1 Answers  


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

0 Answers  


Categories