Interested to Buy Any Domain ? << Click Here >> for more details...
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
- 2 Answers
- 11217 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash
We can do in this way as well:
In the same job,
SeqFile--->Target1
SeqFile--->Target2
SeqFile--->Target3
for Target1,
add Filter condition in the SeqFile as below:
Head -1
for Target2,
add Filter condition in the SeqFile as below:
Tail -1
for Target3,
add Filter condition in the SeqFile as below:
sed '1,$ d'
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How will you move hashed file from one location to another location?
Differentiate between datastage and informatica?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are some different alternative commands associated with "dsjob"?
How a routine is called in datastage job?
How many Key we can define in remove duplicate stage?
What is the difference between Datastage 7.5 and 7.0?
Describe the main features of datastage?
How do you start developing a datastage project?
what is the use of skid in reporting?
What are the types of hashed files in data stage
What could be a data source system?
in oracle target stage when we use load option and when we use upsert option?
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
How do y read Sequential file from job control?
