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 is the precedence of stage variables,derivations, and constraints?

1063

---

What is meta stage?

1167

---

I have a few records just I want to store data in to targets cycling way how?

2340

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

992

---

What are sequencers?

1093

---

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

1048

---

options available in sequence job to run,validate?

1296

---

Which algorithm you used for your hashfile?

1163

---

What is use Array size in datastage

1764

---

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

1133

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3453

---

What is "fatal error/rdbms code 3996" error?

1248

---

Define Merge?

1298

---

What are some prerequisites for datastage?

1076

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1047

---