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 can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how to implement scd2 in datastage 7.5 with lookup stage
What is the process of killing a job in datastage?
Difference between server jobs & parallel jobs?
What is the purpose of pivot stage and types of containers in datastage
How do you register plug-ins?
Differentiate between validated and Compiled in the Datastage?
Define orabulk and bcp stages?
What are the some differences between 7.x and 8.x version of datastage?
Differentiate between data file and descriptor file?
What is the difference between account and directory options ?
How do you import and export the datastage jobs?
What are the different common services in datastage?
why do u need the IOS upgradation in a FC switch
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination