Answer / lakshmi srinivas

By using convert function in transformer,we can implement
that....

Answer / manish

Using Convert function we can achieve this:

Convert('&',' and ',column string)

Answer / srinu

using sequential file using unix command sed s/&/and/g we
will get answer

Answer / bharath

hi,
please take a look on below,


seq_src------->ext_flter----->seq_tgt

in external filter give the
filter command = sed s/"&"/" And "/g command.

**Note: on ampersand (&) symbol you must give the double
quotes (""). With out this it doesn't populate.

Answer / blueboys

Dear Srinu,

I am accepting your answer , but I need it by
using data stage functions

Answer / sree

using expersion
u can create o/p in that write
replacestr(1,columnname,'&','and')

Answer / srinu

hi blueboys
only that answer is proper answer.....interview expected
that answer only.........datastage it is not possible........

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

Can you explain players in datastage?

0 Answers  

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

What are the functionalities of link collector?

0 Answers  

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

Highlight the main features of datastage?

0 Answers  

1)Source file contains one record, I want 100 records in target file.

3 Answers  

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

what is the difference between the join and look up explin me one exmple

3 Answers