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

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

options available in sequence job to run,validate?

0 Answers   CTS,

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

how to cleansing data

6 Answers   Cap Gemini,

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

Name the command line functions to import and export the DS jobs?

0 Answers  

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers