Answer / rajendhar reddy kuthuru

we can use convert function to remove special characters or replace a string

convert('$%^@"!',"",string)-stage var1

it will replace all special characters with a single space

compactwhitespace(stagevar1)

Answer / srinivas

Please use below function.
convert('!@#$%^&*','',string)

No need of the give space in between codes

Only one step to solve this.

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

Explain datastage architecture?

1 Answers  

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1 Answers  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

CHANGE CAPTURE

1 Answers   CTS,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

What are the different options associated with dsjob command?

1 Answers  

---

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

1 Answers  

---

What is the precedence of stage variables,derivations, and constraints?

1 Answers  

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---