DSXchange

my oracle table data is
ename
sri<>rama<>krishna

i want to do delete <> before load the data into source sequentialfile.

i have data source side like
ename
xxxxxxxxxx


i want to display target side

ename ename1 ename2
xx x xxxxxxx

how to genrate sequencenumber using transformerstage only?

i have source like this
date
02-06-2010
05-01-2010
23-09-2010


i want to transform target side like this
date
2-6-2010
5-1-2010
23-9-2010

i have source like
balance,drawtime
20000, 8.30
50000,10.20
3000,4.00

i want target like this
balance,drawtime
20000, 20.30
50000,22.20
3000,16.00

anbu wrote:How do you calculate column? Is it based on Empno?

requirement like that
i have also same doubt

i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like

target1
deptno,sal
1,2000
3,4000
4,5000

target2
2,3000
1,2300
5,1100


with out using transformerstage

i have source file like
empno,ename
10, aa
20, dd
30, bb
10, cc
40, kk
30, jj

i want to target like this
empno,ename,column
10, aa 2
20, dd 1
30, bb 2
10, cc 2
40, kk 1
30, jj 2

whether seq file support for unix commands or not

i have data like

table
empno ename
10 sri
20 rama
10 hari
20 krishna


i want to read only empno 10 by using sequential file

hi i have table(source) like empno ename 10 a 20 b 10 c 30 d 20 g 30 h i want to do output like target1 empno ename 10 a 20 b 30 d target2 empno ename 10 c 20 g 30 h

hi i have two tables like X and Y tableA sno,hiredate 1,1-1-2010 1,1-1-2010 1,4-2-2009 1,4-2-2009 tableB sno,hiredate 1,1-1-2010 1,1-1-2010 i want to display output like this ------------ 1,4-2-2009 1,4-2-2009 ( these two records only) Thanks&Regards venkat i

hi i have two tables like emp1,emp2
emp1
1
2
3
4
5

emp2
1
2
3


i want output 4 and 5 records only


Thanks&Regards
venkat

hi
plz give reply for this if possible with diagram.

hi