how to find no.of records in sequntial file itself?
Answer Posted / 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 |
Post New Answer View All Answers
Define meta stage?
What steps should be taken to improve Datastage jobs?
Name the different sorting methods in datastage.
How to reverse the string using unix?
Define data aggregation?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How many areas for files does datastage have?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the different type of jobs in datastage?
Differentiate between datastage and datastage tx?
Difference between sequential file and data set?
What are the processing stages?
What are the partitioning techniques available in link partitioner?
What is difference between join, merge and lookup stage?
Which commands are used to import and export the datastage jobs?