Answer Posted / 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 are stage variables and constants?

1149

---

How do you start developing a datastage project?

1113

---

How to implement complex jobs in data stage?

1113

---

Name the command line functions to import and export the DS jobs?

1158

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1159

---

What is job control?

1119

---

What is the use of datastage designer?

1158

---

Explain datastage architecture?

1404

---

what is the use of skid in reporting?

2381

---

How many types of views are there in a datastage director?

1296

---

Define orabulk and bcp stages?

1125

---

What are the functionalities of link partitioner and link collector?

1010

---

What is the difference between operational data stage (ods) and data warehouse?

1246

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

---

Difference between server jobs & parallel jobs?

1082

---