DSXchange

Hi,

I think Alnum() checks for Alphabets Or Numbers Or AlphaNumerics in a string.
Not only AlphaNumerics.

=========================
RPhani

I think, You can get the desired output by the below process. 1)Source Stage 2)Sort stage Key=Account Sort Key Mode=Don't sort(previously sorted) Key=Debit/Credit Create Cluster Key Change Column=Yes 3)Transformer: Sv1=1 Sv2=If Cluster Key change column=1 then SV1 else Sv2+1 Take 2 constraints and 2...

Hi,

I think one more way to generate unique numbers.

Prepare a procedure and call it to job by StoredProcedure Stage.

Use this STP Stage before loading data to target.

Thanks,
RPhani

Hi,

I think the same code work for your scenario.

--------------------------------------
Phani

Hi,

IsValid() , If..Then..Else combination may work

----------------
Phani

Hi,

You can get the required o/p by If -Then- Else with KeyChangeColumn(1 and 0) and StageVariables.

----------------------------
RPhani

Hi,

Try this:
Upcase(Left(Column_name,1)):Column_name[2,Len(Column_name)-2]:Upcase(Right(Column_name,1))

-----------------------------------------
RPhani

Hi,

1)Your DS version ?

--------------------------
RPhani

Hi,

Use Transformer Looping concept.

---------------------
RPhani

Hi Sushma, The below procedure will help for your Scenario. 1)EMPNo of HARITHA(100,102,104) are reference to a LookUp. 2)It's O/P has 5 recs and Rej has 4 recs(101,103). 3)Take a Transformer constaint ENAME='HARITHA' on LookUp O/P. 4)Funnel with LookUp Rejects Thanks in advance for alternate ideas. ...

Hi,

1)Please check Target column datatype.
2)'%mm%dd%yyyy' is Varchar(8) But defalt value in Else part is 10.

-------------------
RPhani

Hi,

Use Transformer Looping concept.

----------------------------------------
R.Phani

Hi,

DataTypes and Lengths Of duplicate columns?CHAR or Varchar?

I think no differnce in algorithm.
----------------------
Phani

Thanks Arndw,

I am using Oracle Connector stage.

-----------------------------------------------
Thanks,
Phani

Thanks Arndw,

AutoCommit is off in my db.
Thus I took After Sql=commit and run the Job.

Eventhough records are not deleting.Only inserting.

Where shoud i need to take Commit statement?Please specify.

----------------------------------------
Thanks,
Phani