Answer / satish

Hi

First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable 

Str( DSLink2.column_2, DSLink2.Column_1).

Drag and drop the stage variable to required output column,
finally load the data in target. 

Answer / subbuchamala

Ex:
Str( "a", 3)---->aaa
Str( "b", 4)---->bbbb

Solution:
use below transformer Logic in Output Col Derivation:

Str(DSLink2.col2, DSLink2.Col1)--->Output_Col(Output Column)

Output:

Output_Col
aaa
bbbb
ccccc

Answer / naresh

Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable 
finally load the data in target.

Answer / geetha

use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.

how to configure databases through datastage

2 Answers  

---

How do you import and export the datastage jobs?

0 Answers  

---

What are the different types of lookups in datastage?

0 Answers  

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

How do you get log info into a file?

1 Answers  

---

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,

---

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,

---

To see hidden files in LINIX?

0 Answers   CTS,

---