Answer / swamy

Use field function in transformer stage. This function
performs based on delimeter... so, you can use that field
function. like field(delimeter, occurance) - field means
(input column) delimeter ("-") occurance(2) ...

Answer / madan

use substr in transformer and divide it in to 2 fields as
required

Answer / ashutosh g

use Row splitter as tranform stage and specified the column
name.

Answer / balu

We are using LEFT and RIGHT TRIM function in transform stage.

Answer / palgun

Simple.....use da delimiter as --

SCH-AS--1010

Does dat solve ur prob??

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

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 Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

How can you join flat file, oracle as a sources?

4 Answers   IBM,

---

What are the differences between datastage and informatica?

0 Answers  

---