Interested to Buy Any Domain ? << Click Here >> for more details...
how to find no.of records in sequntial file itself?
- 4 Answers
- 21692 Views
- I also Faced
- E-Mail Answers
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 |
what is sparse lookup?
What are the types of views in datastage director?
what is the custome stage in datastage? how can we impliment that one? plz tell me
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are constraints and derivations?
Can you explain engine tier in information server?
What are the areas of application?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
root tree will find which is server job and which is parallel job?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
Teradata 
