Interested to Buy Any Domain ? << Click Here >> for more details...
A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?
- 3 Answers
- 9993 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
flat file nothing but take sequence file use sed -n '1,50p'
using this command in filter option in the first running job.
second running job we use sed -n '51p,100' using this command
in this way we use other two times running job.....
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can we improve performance of data stage jobs?
What are the different options associated with dsjob command?
What is the difference between hashfile and sequential file?
Name the command line functions to import and export the DS jobs?
How to implement complex jobs in data stage?
What is the importance of the exception activity in datastage?
sed,awk,head
How many types of views are there in a datastage director?
Triggers,VIEW,Procedures
Explain datastage architecture?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is "fatal error/rdbms code 3996" error?
how to sort two columns in single job in datastage.
What is the difference between passive stage and active stage?
What is the use of datastage director?
