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 can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

How to display errors in datastage?

1 Answers   TCS,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

Differentiate between validated and Compiled in the Datastage?

0 Answers  

---