Answer / 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'

Answer / kumar

As you have a single text file as Source. Use folloowing
approach to get the desired output.

Head1 Target1

Seq. File Copy Tail2 Target2

Head3 Tail Target3
Steps:
1.> Read your source file using sequential file stage.
2.> Pass the records to copy stage and take 3 output link.
3.> 1 to Head stage head1, 2nd to Head2 and 3rd to Head3.
4.> In the 1st Head Stage Head1, in the properties specify
1, it will pick up the 1st record and make that record to
target 1.

5.> Similarly, to capture last record in target2, in Tail
stage property mention 1. It will take last record and pass
it to target2.

6.> To load rest records 1st using head stage, capture top
records say, if u have 10 records in the source pick top 9
records using head stage then use tail stage followed by
head stage and mention 8, it will pick all records except
1st one. then u can load these to target3.

If u get confused ask me ....

Thanks
Kumar

What is the difference between in process and inter process?

0 Answers  

---

what about data stage requirement

1 Answers  

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

What are the benefits of datastage?

0 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---