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 |
Define orabulk and bcp stages?
detail about sdlc
what is a nodemap constraint
WHAT are unix quentios in datastage
What is the difference between hashfile and sequential file?
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..
How do you load 10 different sources with 10 different layouts to 10 different tables?
source contains 2 columns comes to target 4 columns how
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.
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What are stage variables, derivations and constants?
How do y read Sequential file from job control?