col1
123
abc
234
def
jkl
768
opq
567
789
but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 8 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 2 Yes | 1 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
What are the steps required to kill the job in Datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is a merge in datastage?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
How to generate surrogate key without using surrogate key stage?
Explain how a source file is populated?
What are datastage sequences?
what is parameterset?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks