DSXchange

Another thing i noticed is :
when the input is 00000000, StringToDecimal does not work.

What happens when you try to convert it to decimal[8,8]? Does it give any error?

it convert any values to 0.00000000

I have input of char( 8 ), how to convert it to decimal ( 8,8 ) in a transform stage.
it's working fine to convert decimal ( 8,0 ).

Yes remove duplicate will work,
as i and Ray.Wurlod mentioned earlier, rule is same as remove duplicate.

partition and sort on on F1 asc, F2 Desc
and keep 1st
or
partition and sort on on F1 asc, F2 Asc
and keep last

sorry the varibale value shoukd be

Sprev=(If LOC<>'' Then LOC Else Sprev)

Use transformer stage:
define a stage varialbles

Sprev=(If LOC='' Then LOC Else Sprev)

and map this variable to the LOC Column

it is tested one, there may be some mistake you are doing: the order of defining stage variable is very important, i just noticed it was wrong earlier. try this you can get the result by using combination of a SORT and transformation Stage....... from file Sort on F1 Asc, F2 desc; In Tnasform stage ...

check if you have set "Reset if Required" for the job

Is it possible in Oracle to pass any value in FK column?? NO. so how can you pass in Dstastage.... yes you can pass any value, if you have disabled the contrant in the Table...and before enabling the constrants in table, check what are the different values in the table for deptno column, insert all ...

just call IBM/Ascential support...

Yes, you can use Teradata API stage plugin.... if you don't have it get it from ascential and register the plugin..

check the cutomize option in the repository area.......
If its not there you can get it from ascential, or then register the plugin

Its same funda as used to remove duplicate your data is like F1 F2 F3 --------------- 1 2 3 1 4 2 6 7 8 6 9 4 after sorting you will get F1 F2 F3 --------------- 1 4 2 1 2 3 6 9 4 6 7 8 after the tansform one link will give you F1 F2 F3 --------------- 1 2 3 6 7 8 Other link will give you F1 F2 F3 -...

Yes, through ODBC interprise Database stage.

you can get the result by using combination of a SORT and transformation Stage....... from file Sort on F1 Asc, F2 desc; In Tnasform stage declare two stage variable VNext and VPriv VNext=F1 Vpriv=Vnext have two output from tansform 1st link constraint Vpriv<>Vnext 2nd link constraint Vpriv=Vnext