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

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

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

3 Answers   TCS,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

What is use Array size in datastage

0 Answers  

what is the diff between sequential file and fileset stages?

3 Answers  

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

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,

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers