DSXchange

i get this logic by putting initial value as maximum as the data type max value

good idea sreeni.
but it gives only one record as output.

when i am using 3 stage variables.it is is giving output like this
0
45
56
65
65
logic:
i hav taken 3 stg variables.
i draged marks col in to 1st & 3rd vars.
in 2 nd var i write
if stg1<stg2 then stg1 else stg2
but i am expecting 45 as final value

i am trying to find minimum value in a column using transformer. my data is like this marks 45 56 90 65 80 i applied below logic.i have taken 2 stage variables. varmin -->i drag the marks column to this. cmp -->Min(varmin,cmp) but i am getting all zero's in output column. can anyone please help me i...

i didn't notice that i am posting topics like that. sorry for that. here i want to mention one thing that, all posts i posted here are tried by me and some are not up to my knowledge.i am the beginner for datastage. Actually i want to shorten the question for readability purpose. so all posts posted...

is that guide is 8.1 or 8.5?
coz i didn't find looping

source
a
a_b
a_b_c
a_b_c_d

target
a
b
c
d

Find out first 2 records of each deptno?

source
delpno,name
10,vinodh
10,ashok
10,anil
10,raj
20,usha
20,puja
30,ravi

In source file i have 1 record,in target i want that record 100 times.

can any one suggest me to do this task.

I Want to send Alternate Records to one target and remaining other target without using transformer.

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

target1
deptno,sal
1,2000
3,4000
4,5000
target2
deptno,sal
2,3000
1,2300
5,1100

thnx ntr.its working
But i am not able to get proper output with pivot stage.
its showing output as
j
p
m

i didn't find the Pivot Definition tab of the Stage page as mentioned in parallel job developer guide

ntr wrote:source----copy------funnel---output

But funnel stage is showing only 2 columns c1,c2.then how to combine the data? and what is n1(name)?

source
c1,c2,n1,n2,n3
abc,eng,john,peter,mike

target
c1,c2,name
abc,eng,john
abc,eng,peter
abc,eng,mike

but that is not my requirement...