Answer / mike

in transformer stage, used Alpha function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic.

Answer / srinu

source->transormer->fileter1->transformer1
->filter2 ->tranformer2 joinstage ->target
in source:-
take i/p
transformer :
append new collumn and apply char function is alpha
filter1:
separate 0
filter2:
separate 1
transformer1
add another column @outrownum
transformer 2
add another column @outrownum
we join on @rownum column we will get
do perfect we get answer

Answer / vaka

In Transformer stage, used Num function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic,0 then Numeric after using
filter give the where clause=0 output link 0(trg1) and
where clause=1 output link 1(trg2)
trg1
123
234
768
567
789

trg2
abc
def
jkl
opq

Answer / eswar

this is not working plz explain clearly

Answer / vijaya

Hi Eswar,

It works nicely.try once again

Answer / shiva

In the transformer stage we have funcitons like alfa and
numaric so we go for that stage and write one condition if
alfa() then target1 and then go for constraints then put the
otherwise option then automatically numaric values will be
stored in anthor target table.

Answer / prasad

hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.

Answer / kiran

By using transformer stage we can implement this
in transofrmaer functions like alfa funcation
and numric functions these functions are using to
implement this

Answer / srinu

at first generate row number column column 'number' then in transformer stage
create one column in constrains [ mod(number,2)=0] for this logic we get all even records mean all strings to one target
and for the second target kept a reject link all the numeric get a side

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

how to call sequential generator in datastage?

1 Answers   IBM,

how to load meta data

2 Answers   IBM,

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

Name the different sorting methods in datastage.

0 Answers  

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

how to handle null values using transformer stage?

1 Answers  

What are the unit test cases you used in your project?

1 Answers   CSC, HY,