Interested to Buy Any Domain ? << Click Here >> for more details...
how to find no.of records in sequntial file itself?
- 4 Answers
- 21663 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 |
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the different options associated with dsjob command?
Differentiate between datastage and informatica?
How To find the location of APT_confid file
Where do the datastage jobs get stored?
How to lode data in sequntional files perform faster?
How to RD using transformer?
Can aggregator and transformer stages use to sort the data? How ?
how can u find out the datastage job is running on how many nodes
whats relation between configuration file and datasets?
What could be a data source system?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
Teradata 
