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

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

What is the use of datastage designer?

0 Answers  

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

What are the different kinds of views available in a datastage director?

0 Answers  

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,