Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 16576 Views
- Patni, I also Faced
- E-Mail Answers
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 |
can we use sequential file as a lookup
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
What could be a data source system?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
source file contains 100 records, i want 10 records in target file how it possible in datastage
What r the existing server jobs in parallalism?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
How can we achive parallelism
What is difference between join, merge and lookup stage?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
In one project how many shared containers are created?
Describe stream connector?
Teradata 
