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........

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

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

2 Answers  

What is RCP?

2 Answers   TCS,

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

What is the difference between datastage and informatica?

0 Answers