DSXchange

premupdate wrote:Have you tried OCONV function..

I have choosed mistakenly server edition but this prob related to parllel edition

Hi ,

I have source format like 1456(2007-10-01) and in target i want to populate date as 20071001.

I have gone through the search but i didn't.

Thanks,
Harikumar

Hi
when I was tried to run sequencer its got aborted by following error.
will some one give idea.

SEQ_J_Date_FiscalDate..JobControl (@Routine_Activity_Min_Fiscal_Year): Controller problem: Unhandled failure (1998) encountered calling routine DSU.ReadParameterFile


Thanks,
Raju.

Hi In the existing sequencer error notification e-mail setuped the same for both aborts and data error .so I am getting same mail for both aborts and errors. Now I want to modify the existing code for getting different mails for abort and errors. like when ever job got aborted at that time i want to...

anbu wrote:From your input sequnum=empno*2.

I dont see any odd numbers in your sequnum. Can you pl explain your requirement?

hi for the same table one of the case i want to genrate oddnumers like

empno,sal,sequnum
1,2000,1
2,4000,3
4,5000,5
3,6000,7
5,4500,9
6,3400,11 like this please tell me the logic

hi my source is like

empno,sal
1,2000
2,4000
4,5000
3,6000
5,4500
6,3400

target is like

empno,sal,sequnum
1,2000,2
2,4000,4
4,5000,6
3,6000,8
5,4500,10
6,3400,12

plz tell me the clear logic for generate evennumbers and oddnumbers using transformer stage(stagevariables)

ray.wurlod wrote:It's called a (horizontal) pivot, and you can achieve it using a Pivot stage. ...

by using pivotstage(horizantal) i am trying but i am unable to get the exact data what i am expected so please give correct answer

my source table is like

col1,col2,col3
1,x,y
2,a,b


i want target like

col1,col2
1,x
1,y
2,a
2,b

hi
i my source table having 5 columns but target i want only empty file(with out columns) by using transformer

i know the only by using Director but i want other than that

the source table sal empno deptno sal 1 10 10,000 2 20 20,000 3 30 30,000 1 40 15,000 2 50 22,000 3 60 25,000 . . . . . . . . . . . . . . . . . . find the which employ having max(sal) in which deptno(output should be display all columns) target like this ---------- empno deptno sal 1 40 15,000 2 50 ...

to link1
111
222

to link2
111
333

i have emp table like

empno
111
222
333

i have two target links

target link1
empno
111
222

target link2
empno
111
333

NOTE:without using switch AND filter stages

how to do funnel in server edition

i have source table like
empno,salary
10,1000
20,4000
30,5000
10,3000
30,5000
40,6000

i want to do find who are the employees having salary more than average salary

cal anybody tell how can we solve this using stages