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

Question Posted / kkk

4 Answers
21519 Views
I also Faced
E-Mail Answers

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 you explain repository tables in datastage?

0 Answers

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers Alpharithm Technologies,

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers HCL,

How a source file is populated?

0 Answers

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers TCS,

What is diff between Junk dimensions and conform dimension?

4 Answers Polaris,

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers IBM, TCS,

WHAT ARE THE COMMON ERRORS IN DATA STAGE?