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
how to add a new records into source?
What are sequencers?
how to export or import the jobs in .ISX file
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Is possible to create skid in dim,fact tables?
Difference between data warehousing and olap?
What is a datastage job?
Where do the datastage jobs get stored?
What is the purpose of pivot stage?
What are system variables and sequencers in datastage
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How a source file is populated?
What is oci?
What is the difference between passive stage and active stage?