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 |
how can we extract data with out having any common column
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
How a source file is populated?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Can you implement SCD2 using join, transformer and funnel stage?
how to handle null values in sequential file?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
What is orabulk stage?
What is the project in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE