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
- 11226 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
Define Merge?
How do you start developing a datastage project?
What are the different types of lookups in datastage?
explain about citrix scheduling tool in datastage
How you Implemented SCD Type 1 & Type 2 in your project?
How many types of views are there in a datastage director?
What are the types of containers?
which r the connectors used in san?
What are system variables and sequencers in datastage
Difference between server jobs & parallel jobs?
Describe routines in datastage? Enlist various types of routines.
What is meta stage?
What are the features of datastage flow designer?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the method of removing duplicates, without the remove duplicate stage?
