Answer Posted / vs

First and foremost thing, put the following data in a text file.

00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256

Follow the steps:

Take following 3 stages:

1. Sequential File
2. Transformer
3. Dataset/Sequential File

STAGE 1:

1. Sequential File Properties

Source-->File = browse & select the text file containing the
above data.
Read Method = Specific File(s)

Go to Columns Tab:
Give column name (any name), SQL Type = Varchar, length = 50
(Make sure you take the minimum length as 20 since the
character length in the input file is 20).

Now, click on the "Load" option at the bottom and import the
table definitions by choosing "Sequential File Definitions".
After the table definitions are imported. Double click on
the imported table definition. Click OK.

STAGE 2:

Transformer Properties:

Click on the O/p column, and create 4 Columns at the bottom.

Column Name SQL Type Length
Field1 Varchar 50
Field2 Varchar 50
Field3 Varchar 50
Field4 Varchar 50

Create 4 Stage variables:

Derivation Stage
Variable
Left(inputcolumnname,5) F1
Right(Left(inputcolumnname,10),5) F2
Right(Left(inputcolumnname,15),5) F3
Right(inputcolumnname,5) F4

Map the above stage variables by dragging and dropping into
the below O/p table

O/p Table

Derivation Column Name
F1 Field1
F2 Field2
F3 Field3
F4 Feild4

STAGE 3:

Dataset File Stage/Sequential File Stage Properties:

Double click and File = browse the output file path.

If it's sequential, .txt || Dataset File, .ds


Hope this helps you !!! If you follow the above procedure,
you must get the out put correct!!!

All The Best !!!

Thanks & Regards,
VS

What is a quality stage in datastage tool?

1131

---

How can we improve performance of data stage jobs?

1070

---

how to delete one row in target dataset

3166

---

Describe stream connector?

1360

---

What are the functionalities of link collector?

1138

---

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

2414

---

How can we improve the performance in datastage?

1147

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2116

---

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

1064

---

Where the datastage stored his repository?

1141

---

What is the difference between an operational datastage and a data warehouse?

1212

---

Highlight the main features of datastage?

1221

---

Can we use target hash file as a lookup ?

3374

---

What is job control?

1200

---

what is the use of materialized view?

1639

---