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

Define orabulk and bcp stages?

1 Answers  


detail about sdlc

4 Answers  


what is a nodemap constraint

2 Answers   IBM,


WHAT are unix quentios in datastage

2 Answers   TCS,


What is the difference between hashfile and sequential file?

1 Answers  


In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  


How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

1 Answers  


CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,


What are stage variables, derivations and constants?

1 Answers  


How do y read Sequential file from job control?

3 Answers   HP, IBM, Telesis,


Categories