Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,


i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  


Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,


how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,


How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,


I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,


Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  


How can we run same job in 1 day 2 times

4 Answers   IBM,


Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,


Nls stands for what in datastage?

0 Answers  


What is APT_DUMP_SCORE?

2 Answers   IBM,


Categories