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
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How do you generate sequence number in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you register plug-ins?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the precedence of stage variables,derivations, and constraints?
Where the datastage stored his repository?
Whats difference betweeen operational data stage (ods) and data warehouse?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the types of views in datastage director?
What are the stages in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are stage variables, derivations and constants?