how to find no.of records in sequntial file itself?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / simha
hi,
seq file --> go for options --> select row count.
then automatically updated.
| Is This Answer Correct ? | 5 Yes | 13 No |
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.
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
how to run jon in unix back round process what is command use in runing a job?
How to remove duplicates in transformer stage? in parallel mode
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
what is diff b/w datastage 8.1,8.5,8.7?
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
How can we run same job in 1 day 2 times
Is possible to create skid in dim,fact tables?
Nls stands for what in datastage?
What is APT_DUMP_SCORE?